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

Description Source composite view contains data from the base personnel action (PAF) transaction number recorded for the employee.
Key & Frequency One row per person per PAF transaction number

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_APPLY_DATE Paf Apply Date Date transaction was applied. DATE  

NOBTRAN

NOBTRAN_APPLY_DATE

PAF_APPLY_IND Paf Apply Indicator Indicator to apply transaction to the database. VARCHAR2(1)  

NOBTRAN

NOBTRAN_APPLY_IND

PAF_APPLY_USER_ID Paf Apply User ID User ID who applied transaction to the database. VARCHAR2(30)  

NOBTRAN

NOBTRAN_APPLY_USER_ID

PAF_APPROVAL_CATEGORY Paf Approval Category Approval category that represents the purpose of the personnel action. Designates the action taken on the part of the employee such as the transfer of an employee from one department to another. VARCHAR2(6)  

NOBTRAN

NOBTRAN_ACAT_CODE

PAF_APPROVAL_CATEGORY_DESC Paf Approval Category Description Approval category description. VARCHAR2(30)  

NTVACAT

NTVACAT_DESC

PAF_COMMENT_COUNT Paf Comment Count Number of comment records for this transaction and sequence number. NUMBER  

FUNCTION

NOKODSF.F_GET_PAF_COMMENT_COUNT

PAF_EFFECTIVE_DATE Paf Effective Date Date the personnel action record became effective. DATE  

NOBTRAN

NOBTRAN_EFFECTIVE_DATE

PAF_ORIGINATOR_CREATE_DATE Paf Originator Create Date Date the personnel action is created. DATE  

NOBTRAN

NOBTRAN_CREATED_DATE

PAF_ORIGINATOR_USER_ID Paf Originator User ID User id who submitted the personnel action activity. VARCHAR2(30)  

NOBTRAN

NOBTRAN_ORIGINATOR_USER_ID

PAF_SUBMIT_DATE Paf Submit Date Date the personnel action is submitted to start the transaction through the approval queue. DATE  

NOBTRAN

NOBTRAN_SUBMISSION_DATE

PAF_SUBMIT_USER_ID Paf Submit User ID User id who submitted the a personnel action activity. VARCHAR2(30)  

NOBTRAN

NOBTRAN_SUBMITTOR_USER_ID

PAF_TRANSACTION_ACTIVITY_DATE Paf Transaction Activity Date Date of last activity on this record. DATE  

NORTRAN

NOBTRAN_ACTIVITY_DATE

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

NOBTRAN

NOBTRAN_TRANSACTION_NO

PAF_TRANSACTION_STATUS Paf Transaction Status Status of the personnel action transaction. VARCHAR2(1)  

NOBTRAN

NOBTRAN_TRANS_STATUS_IND

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER  

NOBTRAN

NOBTRAN_PIDM

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: