Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
APPROVER_UID
|
Approver UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER(8)
|
|
GOBEACC
|
GOBEACC_PIDM
|
APPROVER_USER_ID
|
Approver User ID
|
Person's user identification who approved the event.
|
VARCHAR2(30)
|
|
FRREVNG
|
FRREVNG_APPROVED_BY_USER_ID
|
CURRENT_DATE
|
Current Date
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
|
NA
|
SYSDATE
|
DOMAIN_VALUE
|
Domain Value
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
|
NA
|
NA
|
EVENT_DUE_DATE
|
Event Due Date
|
|
DATE
|
|
|
|
EVENT_SEQUENCE_NUMBER
|
Event Sequence Number
|
|
NUMBER
|
|
|
|
EVENT_STATUS
|
Event Status
|
|
VARCHAR2(1)
|
|
|
|
EVENT_STATUS_ACTIVITY_DATE
|
Event Status Activity Date
|
|
DATE
|
|
|
|
EVENT_STATUS_DATE
|
Event Status Date
|
|
DATE
|
|
|
|
EVENT_STATUS_USER_ID
|
Event Status User ID
|
|
VARCHAR2(30)
|
|
|
|
GRANT_EVENT
|
Grant Event
|
User-defined event identification assigned to the grant.
|
VARCHAR2(6)
|
|
FRREVNG
|
FRREVNG_EVNT_CODE
|
GRANT_EVENT_DUE_DATE
|
Grant Event Due Date
|
Due date for the event to be satisfied or performed.
|
DATE
|
|
FRREVNG
|
FRREVNG_DUE_DATE
|
GRANT_EVENT_SEQUENCE_NUMBER
|
Grant Event Sequence Number
|
System-generated one-up number related to grant events.
|
NUMBER(3)
|
|
FRREVNG
|
FRREVNG_SEQ_NUM
|
GRANT_EVENT_STATUS
|
Grant Event Status
|
Event status. (S)atisfied, (C)anceled, or (P)ending.
|
VARCHAR2(1)
|
|
FRREVNG
|
FRREVNG_STATUS_IND
|
GRANT_EVENT_STATUS_ACTIVITY_DATE
|
Grant Event Status Activity Date
|
Date record was inserted or updated.
|
DATE
|
|
FRBEVNG
|
FRREVNG_ACTIVITY_DATE
|
GRANT_EVENT_STATUS_DATE
|
Grant Event Status Date
|
Date when the grant event was satisfied, performed or canceled.
|
DATE
|
|
FRREVNG
|
FRREVNG_STATUS_DATE
|
GRANT_EVENT_STATUS_USER_ID
|
Grant Event Status User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
|
FRBEVNG
|
FRREVNG_USER_ID
|
GRANT_ID
|
Grant ID
|
Unique user-defined or system generated one-up number for this grant.
|
VARCHAR2(9)
|
|
FRREVNG
|
FRREVNG_GRNT_CODE
|
MIF_DESC
|
MIF Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
|
NA
|
NA
|
MIF_VALUE
|
MIF Value
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
|
NA
|
NA
|
RESPONSIBLE_PERSON_UID
|
Responsible Person UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER(8)
|
|
GOBEACC
|
GOBEACC_PIDM
|
RESPONSIBLE_USER_ID
|
Responsible User ID
|
Person's responsible user identification for satisfying the event.
|
VARCHAR2(30)
|
|
FRREVNG
|
FRREVNG_RESPONSIBLE_USER_ID
|
ZONE_VALUE
|
Zone Value
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
|
NA
|
NA
|