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

Banner Operational Data Store
Composite View Target: AN_PERSONNEL_ACTION_GENERAL

Description Source composite view contains data on each personnel action (PAF) transaction number for the employee, position and job suffix where there are updates to biographical, employee or job information..
Key & Frequency One row per person per PAF transaction number per approval type per position per job suffix per apply column

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

NA

NA

NO

NO
JOB_SUFFIX Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(2)

NORTRAN

NORTRAN_SUFF

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
PAF_APPLY_ACTIVITY_DATE Date of last activity on this record. DATE

NORTRAN

NORTRAN_ACTIVITY_DATE

NO

NO
PAF_APPLY_COLUMN Database column that was sent through the approval process. VARCHAR2(30)

NORTRAN

NORTRAN_AUFD_CODE

NO

NO
PAF_APPLY_FORM Data entry form that was sent through the approval process. VARCHAR2(7)

NORTRAN

NORTRAN_AUFM_CODE

NO

NO
PAF_APPLY_STATUS Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled. VARCHAR2(1)

NORTRAN

NORTRAN_APPLY_STATUS_IND

NO

NO
PAF_APPLY_STATUS_DESC Personnel action sequence status description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
PAF_APPLY_TABLE Database table that was sent through the approval process. VARCHAR2(30)

NORTRAN

NORTRAN_AUBK_CODE

NO

NO
PAF_APPLY_VALUE New value entered for the database column. VARCHAR2(500)

NORTRAN

NORTRAN_VALUE

NO

NO
PAF_APPROVAL_TYPE Approval type defaulted for the sequence number per approval category rules. Rule include one record for each basic type of action defined for the approval category, such as establishing a new job assignment or terminating an existing job assignment. VARCHAR2(6)

NORTRAN

NORTRAN_APTY_CODE

NO

NO
PAF_APPROVAL_TYPE_DESC Approval type description. VARCHAR2(30)

NTVAPTY

NTVAPTY_DESC

NO

NO
PAF_SEQUENCE_NUMBER Display sequence for each of field changed in the approval transaction. NUMBER

NORTRAN

NORTRAN_DISPLAY_SEQ_NO

NO

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

NORTRAN

NORTRAN_TRANSACTION_NO

NO

NO
PAF_TRANSACTION_TYPE Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions. VARCHAR2(4)

CALCULATION

CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN'

NO

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

NOBTRAN

NOBTRAN_PIDM

NO

NO
POSITION Position number attached to the personnel action. VARCHAR2(6)

NORTRAN

NORTRAN_POSN

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: