Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: PERSONNEL_ACTION

Description Provides data for the person, transaction number and approval category when a personnel action is entered in the Banner temporary tables. Includes all personnel action header information with current status for applied and pending transactions.
Key & Frequency One row per person per PAF transaction number
Recommended Search Columns PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER,PAF_APPROVAL_CATEGORY

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAF_APPLY_DATE Date transaction was applied. DATE

NOBTRAN

NOBTRAN_APPLY_DATE

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

NOBTRAN

NOBTRAN_APPLY_IND

PAF_APPLY_USER_ID User ID who applied transaction to the database. VARCHAR2(63)

NOBTRAN

NOBTRAN_APPLY_USER_ID

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(63)

NOBTRAN

NOBTRAN_ACAT_CODE

PAF_APPROVAL_CATEGORY_DESC Approval category description. VARCHAR2(255)

NTVACAT

NTVACAT_DESC

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

FUNCTION

NOKODSF.F_GET_PAF_COMMENT_COUNT

PAF_EARNINGS_DEFAULT_IND Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION _EARNING reporting view. Each transaction may also create data in one or more personnel action reporting views. VARCHAR2(1)

FUNCTION

MPKFUNC.F_GET_PERSONNEL_ACTION_IND

PAF_EFFECTIVE_DATE Date the personnel action record became effective. DATE

NOBTRAN

NOBTRAN_EFFECTIVE_DATE

PAF_GENERAL_CHANGE_IND Identifies the actions taken under this personnel action transaction number update either the name, ID, address, telephone number or other biographical data for the person. General changes may also include changes to columns on the employee and or job records. The details of these transactions maybe found in the PERSONNEL_ACTION_GENERAL reporting view. Each transaction may also create data in one or more personnel action reporting views. VARCHAR2(1)

FUNCTION

MPKFUNC.F_GET_PERSONNEL_ACTION_IND

PAF_LABOR_DISTRIBUTION_IND Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION_LABOR_DIST reporting view. Each transaction may also create data in one or more personnel action reporting views. VARCHAR2(1)

FUNCTION

MPKFUNC.F_GET_PERSONNEL_ACTION_IND

PAF_ORIGINATOR_CREATE_DATE Date the personnel action is created. DATE

NOBTRAN

NOBTRAN_CREATED_DATE

PAF_ORIGINATOR_USER_ID User id who submitted the personnel action activity. VARCHAR2(63)

NOBTRAN

NOBTRAN_ORIGINATOR_USER_ID

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 User id who submitted the a personnel action activity. VARCHAR2(63)

NOBTRAN

NOBTRAN_SUBMITTOR_USER_ID

PAF_TRANSACTION_ACTIVITY_DATE Date of last activity on this record. DATE

NOBTRAN

NOBTRAN_ACTIVITY_DATE

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 Status of the personnel action transaction. VARCHAR2(63)

NOBTRAN

NOBTRAN_TRANS_STATUS_IND

PAF_TRANSACTION_STATUS_DESC Personnel action transaction status description. VARCHAR2(255)

FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE = PAF_TRANSACTION_STATUS

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

NOBTRAN

NOBTRAN_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA



Ver: 9.1