Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVITY_DATE
|
ACTIVITY DATE: The date that the information for the row was inserted or updated in the GORSDAV table.
|
DATE
|
GORSDAV
|
GORSDAV_ACTIVITY_DATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ATTRIBUTE_NAME
|
Attribute Name: The name of the attribute.
|
VARCHAR2(30)
|
GORSDAV
|
GORSDAV_ATTR_NAME
|
NO
|
NO
|
ATTRIBUTE_VALUE
|
Value: The Attribute Value.
|
VARCHAR2(4000)
|
CALCULATION
|
CASE SYS.ANYDATA.GETTYPENAME(GORSDAV_VALUE)
|
NO
|
NO
|
DISCRIMINATOR
|
Discriminator: The discriminator value for multiple valued attributes.
|
VARCHAR2(64)
|
GORSDAV
|
GORSDAV_DISC
|
NO
|
NO
|
DISCRIMINATOR_CODE
|
Discriminator Code: The Discriminator associated with this Attribute.
|
VARCHAR2(255)
|
GORSDAM
|
GORSDAM_SDDC_CODE
|
NO
|
NO
|
DISCRIMINATOR_METHOD
|
Discrimination Method: The method used to discriminate. I for Index, S for Select Statement, U for user defined in table GORSDDV.
|
VARCHAR2(255)
|
GOBSDDC
|
GOBSDDC_METHOD
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PARENT_TABLE_PK_COL1
|
Primary Key Parent Table: First column of the composite Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
CALCULATION
|
SUBSTR(GORSDAV_PK_PARENTTAB,)
|
NO
|
NO
|
PARENT_TABLE_PK_COL2
|
Primary Key Parent Table: Second column of the composite Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
CALCULATION
|
SUBSTR(GORSDAV_PK_PARENTTAB,)
|
NO
|
NO
|
PARENT_TABLE_PK_COL3
|
Primary Key Parent Table: Third column of the composite Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
CALCULATION
|
SUBSTR(GORSDAV_PK_PARENTTAB,)
|
NO
|
NO
|
PARENT_TABLE_PK_COL4
|
Primary Key Parent Table: Fourth column of the composite Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
CALCULATION
|
SUBSTR(GORSDAV_PK_PARENTTAB,)
|
NO
|
NO
|
PARENT_TABLE_PK_COL5
|
Primary Key Parent Table: Fifth column of the composite Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
CALCULATION
|
SUBSTR(GORSDAV_PK_PARENTTAB,)
|
NO
|
NO
|
PARENT_TABLE_PK_COL6
|
Primary Key Parent Table: Sixth column of the composite Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
CALCULATION
|
SUBSTR(GORSDAV_PK_PARENTTAB,)
|
NO
|
NO
|
PARENT_TABLE_PRIMARY_KEY
|
Primary Key Parent Table: The Primary key of of the record in the Parent table.
|
VARCHAR2(512)
|
GORSDAV
|
GORSDAV_PK_PARENTTAB
|
NO
|
NO
|
PRIMARY_KEY_COLUMNS
|
Primary Key Dynamic SQL: The SQL to generate the record ID from ROWID in Banner Table Name.
|
VARCHAR2(2000)
|
GOBSDTB
|
GOBSDTB_PK_DYNSQL
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
TABLE_NAME
|
Table Name: The name of the table supplemented by the attribute.
|
VARCHAR2(30)
|
GORSDAV
|
GORSDAV_TABLE_NAME
|
NO
|
NO
|
USER_ID
|
USER IDENTIFICATION: The unique identification of the user.
|
VARCHAR2(30)
|
GORSDAV
|
GORSDAV_USER_ID
|
NO
|
NO
|