Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_PERSONNEL_ACTION_COMMENT

Description Contains text lines associated with the personnel action (PAF) transaction number for the person.
Key & Frequency One row per person per PAF transaction number per PAF sequence number per comment

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
CURRENT_DATE Current Date   DATE      
DOMAIN_VALUE Domain Value Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA

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

PAF_COMMENT Paf Comment Comments recorded by the user related to this personnel action transaction and sequence number. VARCHAR2(4000)  

NORCMNT

NORCMNT_COMMENTS

PAF_COMMENT_ACTIVITY_DATE Paf Comment Activity Date Date of last activity for the record. DATE  

NORCMNT

NORCMNT_ACTIVITY_DATE

PAF_COMMENT_DATA_ORIGIN Paf Comment Data Origin Source system that created or updated the row. VARCHAR2(30)  

NORCMNT

NORCMNT_DATA_ORIGIN

PAF_COMMENT_SEQUENCE_NUMBER Paf Comment Sequence Number Display sequence for each of field changed in the approval transaction. NUMBER  

NORCMNT

NORCMNT_SEQ_NO

PAF_COMMENT_USER_ID Paf Comment User ID Oracle ID of the user who created or changed the record. VARCHAR2(30)  

NORCMNT

NORCMNT_USER_ID

PAF_TRANSACTION_NUMBER Paf Transaction Number System-generated number that is created when you enter information pertaining to an Electronic Personnel Action. NUMBER  

NORCMNT

NORCMNT_TRANSACTION_NO

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER      
ZONE_VALUE Zone Value Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: