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