GTVSCOD GTVTRTP GXRETID GXRTPID

Model Electronic Data Interchange


Model Label : Banner General Electronic Data Interchange
Path : BANNER DEV/General/ERD/Electronic Data Interchange

List of Objects

Object Name Object Type Layer Name
GTVSCOD TABLE Default
GTVTRTP TABLE Default
GXRETID TABLE Default
GXRTPID TABLE Default

Comments

Model View

''

Table GTVSCOD

Schema Name GENERAL
Label GTVSCOD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSCOD_ELEMENT_ID GTVSCOD_ELEMENT_ID VARCHAR2(4) No *
GTVSCOD_CODE GTVSCOD_CODE VARCHAR2(8) No *
GTVSCOD_DESC GTVSCOD_DESC VARCHAR2(80) No
GTVSCOD_STANDARD_IND GTVSCOD_STANDARD_IND VARCHAR2(1) No *
GTVSCOD_ACTIVITY_DATE GTVSCOD_ACTIVITY_DATE DATE No
GTVSCOD_USER_ID GTVSCOD_USER_ID VARCHAR2(30) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSCOD Unique GTVSCOD_ELEMENT_ID
PK_GTVSCOD Unique GTVSCOD_CODE
PK_GTVSCOD Unique GTVSCOD_STANDARD_IND

Comments

Source Code Comments

EDI STANDARD CODE VALIDATION TABLE: This table contains the standard EDI codes based on element id and standards organization. Data in this table is used to create cross references to various user defined codes that need to
be sent in EDI transactions/messages.

Columns Comments for GTVSCOD_ELEMENT_ID (1)

Source Code Comments

EDI STANDARD ELEMENT ID: The numeric identifier associated with the element as defined by the EDI Standards being used.

Columns Comments for GTVSCOD_CODE (2)

Source Code Comments

EDI CODE: The EDI Standard code value associated with the Standard being used.

Columns Comments for GTVSCOD_DESC (3)

Source Code Comments

EDI CODE DESCRIPTION: The description of the EDI Standard Code.

Columns Comments for GTVSCOD_STANDARD_IND (4)

Source Code Comments

EDI STANDARD: A one character code indicating which EDI Standards Organization the code comes from.

Columns Comments for GTVSCOD_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date the row was last updated.

Columns Comments for GTVSCOD_USER_ID (6)

Source Code Comments

USER ID: The last user that updated the row.

Table GTVTRTP

Schema Name GENERAL
Label GTVTRTP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:36:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVTRTP_CODE GTVTRTP_CODE VARCHAR2(2) No *
GTVTRTP_DESC GTVTRTP_DESC VARCHAR2(30) No
GTVTRTP_ACTIVITY_DATE GTVTRTP_ACTIVITY_DATE DATE No
GTVTRTP_USER_ID GTVTRTP_USER_ID VARCHAR2(30) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVTRTP Unique GTVTRTP_CODE

Comments

Source Code Comments

EDI Transaction Type Code Table.

Columns Comments for GTVTRTP_CODE (1)

Source Code Comments

EDI TRANSACTION TYPE CODE: The two character transaction type code assigned to an EDI Transaction/Message.

Columns Comments for GTVTRTP_DESC (2)

Source Code Comments

TRANSACTION TYPE DESCRIPTION: The description of the two character transaction type code.

Columns Comments for GTVTRTP_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: The date the column was last updated.

Columns Comments for GTVTRTP_USER_ID (4)

Source Code Comments

USER ID: The user id of the last user who updated the column.

Table GXRETID

Schema Name GENERAL
Label GXRETID
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:39:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXRETID_TRTP_CODE GXRETID_TRTP_CODE VARCHAR2(2) No *
GXRETID_TRAN_ID GXRETID_TRAN_ID VARCHAR2(6) No
GXRETID_STANDARD_IND GXRETID_STANDARD_IND VARCHAR2(1) No
GXRETID_EXTRACT_FILE_NAME GXRETID_EXTRACT_FILE_NAME VARCHAR2(15) No
GXRETID_ACTIVITY_DATE GXRETID_ACTIVITY_DATE DATE No
GXRETID_USER_ID GXRETID_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
GXRETID_TRTP_CODE GTVTRTP_CODE GTVTRTP

Index

Index Name Index Type Column Name
GXRETID_KEY_INDEX Unique GXRETID_TRTP_CODE
GXRETID_KEY_INDEX Unique GXRETID_TRAN_ID
GXRETID_KEY_INDEX Unique GXRETID_STANDARD_IND

Comments

Source Code Comments

EDI Transaction ID Table.

Columns Comments for GXRETID_TRTP_CODE (1)

Source Code Comments

EDI TRANSACTION TYPE: The unique two character code that identifies the category of EDI transactions/messages being sent.

Columns Comments for GXRETID_TRAN_ID (2)

Source Code Comments

EDI TRANSACTION ID: The three character EDI X12 transaction ID or the six character EDIFACT message ID.

Columns Comments for GXRETID_STANDARD_IND (3)

Source Code Comments

EDI STANDARD INDICATOR: A one character code designating the EDI standard that applies (X)12, (E)DIFACT.

Columns Comments for GXRETID_EXTRACT_FILE_NAME (4)

Source Code Comments

EDI EXTRACT FILE: The name of the flat file that is created by the Banner EDI process and fed to the EDI translator.

Columns Comments for GXRETID_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date the column was last updated.

Columns Comments for GXRETID_USER_ID (6)

Source Code Comments

USER ID: The user id of the last user who updated the column.

Table GXRTPID

Schema Name GENERAL
Label GXRTPID
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:39:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXRTPID_PIDM GXRTPID_PIDM NUMBER(8,0) No
GXRTPID_PARTNER_ID GXRTPID_PARTNER_ID VARCHAR2(15) No
GXRTPID_STANDARD_IND GXRTPID_STANDARD_IND VARCHAR2(1) No
GXRTPID_TRTP_CODE GXRTPID_TRTP_CODE VARCHAR2(2) No
GXRTPID_TRAN_ID GXRTPID_TRAN_ID VARCHAR2(6) No
GXRTPID_STATUS_IND GXRTPID_STATUS_IND VARCHAR2(1) No
GXRTPID_CTRL_NO GXRTPID_CTRL_NO NUMBER(9,0) No
GXRTPID_SEND_IND GXRTPID_SEND_IND VARCHAR2(1) No
GXRTPID_ACTIVITY_DATE GXRTPID_ACTIVITY_DATE DATE No
GXRTPID_USER_ID GXRTPID_USER_ID VARCHAR2(30) No
GXRTPID_ATYP_CODE GXRTPID_ATYP_CODE VARCHAR2(2) Yes
GXRTPID_ADDR_SEQNO GXRTPID_ADDR_SEQNO NUMBER(2,0) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GXRTPID_KEY_INDEX Unique GXRTPID_PIDM
GXRTPID_KEY_INDEX Unique GXRTPID_ATYP_CODE
GXRTPID_KEY_INDEX Unique GXRTPID_ADDR_SEQNO
GXRTPID_KEY_INDEX Unique GXRTPID_PARTNER_ID
GXRTPID_KEY_INDEX Unique GXRTPID_TRTP_CODE

Comments

Source Code Comments

EDI Trading Partner Table.

Columns Comments for GXRTPID_PIDM (1)

Source Code Comments

PIDM: The PIDM for whom the Trading Partner record is being created.

Columns Comments for GXRTPID_PARTNER_ID (2)

Source Code Comments

TRADING PARTNER ID: A unique ID assigned to the Trading Partner. This must match the id set up in the EDI Software.

Columns Comments for GXRTPID_STANDARD_IND (3)

Source Code Comments

EDI STANDARD INDICATOR: A one character code indicating the EDI Standard being used by the Trading Partner.

Columns Comments for GXRTPID_TRTP_CODE (4)

Source Code Comments

EDI TRANSACTION TYPE: The two character transaction type being set up for this trading partner. The value must be a valid type set up in GTVTRTP.

Columns Comments for GXRTPID_TRAN_ID (5)

Source Code Comments

EDI TRANSACTION ID: The EDI Transaction or Message being used by the Trading Partner.

Columns Comments for GXRTPID_STATUS_IND (6)

Source Code Comments

TRANSACTION STATUS INDICATOR: A one character code indicating the status of the transaction. A = Active, I = Inactive, T = Test.

Columns Comments for GXRTPID_CTRL_NO (7)

Source Code Comments

NEXT CONTROL #: The next control number available to be assigned to an EDI transaction or message of this type being sent for this Trading Partner.

Columns Comments for GXRTPID_SEND_IND (8)

Source Code Comments

SEND INDICATOR: A one character indicator specifying if the Trading Partner transaction or message is to be sent immediately (I) or in batch (B).

Columns Comments for GXRTPID_ACTIVITY_DATE (9)

Source Code Comments

ACTIVITY DATE: The date the column was last updated.

Columns Comments for GXRTPID_USER_ID (10)

Source Code Comments

USER ID: The user id of the last user who updated the column.

Columns Comments for GXRTPID_ATYP_CODE (11)

Source Code Comments

ADDRESS TYPE CODE: The specific address type code associated with the PIDM.

Columns Comments for GXRTPID_ADDR_SEQNO (12)

Source Code Comments

ADDRESS SEQUENCE NUMBER: The specific address sequence number associated with the PIDM and Address Type Code.

Link between GXRETID and GTVTRTP

Caller : GXRETID
Called : GTVTRTP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GXRETID and GTVTRTP GENERAL

Link Foreign Key Between GXRETID and GTVTRTP

Caller : GXRETID
Called : GTVTRTP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GXRETID and GTVTRTP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GXRETID GXRETID_TRTP_CODE GTVTRTP_CODE GTVTRTP (1,1)-(0,n)

Comments