| Data element |
Definition |
| ACTION_ID
Indexed - no
Format - number
May be null? no |
The unique identifier on each action. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system. |
|
CREATE_DT
Indexed - no
Format - date
May be null? no
|
The creation date of the record.
|
| CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record. |
| ID
Indexed - yes (primary key)
Format - number
May be null? no
|
A unique identifier of each review record. |
| LAST_UPDATED
Indexed - no
Format - timespamp
May be null? no
|
The date/time on which the review record was last updated.
|
| REVIEWER_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the reviewer. |
| REVIEWER_NOTES
Indexed - no
Format - varchar2(4000)
May be null? yes
|
Comments entered in FIS by the reviewer, as pertaining to an action.
|
| REVIEW_CD
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the reviewer's disposition toward an action.Use this to join to the FIS_REVIEW_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the review code description. |
| UPD_DT
Indexed - no
Format - date
May be null? no
|
The date the address record was last updated. |
| UPD_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who last updated the record. |
