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_LABOR_DIST

Description Provides the data details for the person, transaction number and approval type when the labor distribution(s) are changed by the personnel action. Includes personnel actions with current status for applied and pending transactions.
Key & Frequency One row per person per PAF transaction number per approval type per position per suffix per labor distribution
Recommended Search Columns PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER,POSITION,JOB_SUFFIX

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACCOUNT Account code that this APPROVAL TRANSACTION was charged. VARCHAR2(63)

NORTLBD

NORTLBD_ACCT_CODE

NO

NO
ACCOUNT_DESC Position account description. VARCHAR2(255)

FTVACCT

FTVACCT_TITLE

NO

NO
ACCOUNT_INDEX Account index code that was used to default the account distribution this APPROVAL TRANSACTION was charged. VARCHAR2(63)

NORTLBD

NORTLBD_ACCI_CODE

NO

NO
ACCOUNT_INDEX_DESC An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(255)

FTVACCI

FTVACCI_TITLE

NO

NO
ACTIVITY Activity code where this APPROVAL TRANSACTION is charged. VARCHAR2(63)

NORTLBD

NORTLBD_ACTV_CODE

NO

NO
ACTIVITY_DESC Position activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

NO

NO
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
CHART_OF_ACCOUNTS Chart of accounts code where this APPROVAL TRANSACTION is charged. VARCHAR2(63)

NORTLBD

NORTLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COST_TYPE Cost type where this APPROVAL TRANSACTION is charged when cost accounting is used. VARCHAR2(63)

NORTLBD

NORTLBD_CTYP_CODE

NO

NO
COST_TYPE_LONG_DESC Cost type long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COST_TYPE_SHORT_DESC Cost type short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ENCUMBRANCE_CALCULATE_END_DATE End date used to calculate future fiscal year encumbrances for a labor distribution. DATE

NORTLBD

NORTLBD_ENC_OVERRIDE_END_DATE

NO

NO
EXTERNAL_ACCOUNT Free form account number to be used to interface to an external finance system. VARCHAR2(63)

NORTLBD

NORTLBD_ACCT_CODE_EXTERNAL

NO

NO
FUND Fund code where this APPROVAL TRANSACTION is charged. VARCHAR2(63)

NORTLBD

NORTLBD_FUND_CODE

NO

NO
FUND_DESC Position fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
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

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

NORTLBD

NORTLBD_SUFF

NO

NO
LOCATION Location code where this APPROVAL TRANSACTION is charged. VARCHAR2(63)

NORTLBD

NORTLBD_LOCN_CODE

NO

NO
LOCATION_DESC Position location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ORGANIZATION_CODE Organization code where this APPROVAL TRANSACTION is charged. VARCHAR2(63)

NORTLBD

NORTLBD_ORGN_CODE

NO

NO
ORGANIZATION_DESC Position organization description. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

NO

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

NORTLBD

NORTLBD_APPLY_STATUS_IND

NO

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

FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS

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

NORTLBD

NORTLBD_APTY_CODE

NO

NO
PAF_APPROVAL_TYPE_DESC Approval type description. VARCHAR2(255)

NTVAPTY

NTVAPTY_DESC

NO

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

FUNCTION

NOKODSF.F_GET_PAF_COMMENT_COUNT

NO

NO
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

NO

NO
PAF_EFFECTIVE_DATE Date the personnel action record became effective. DATE

NORTLBD

NORTLBD_EFFECTIVE_DATE

NO

NO
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

NO

NO
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

NO

NO
PAF_LABOR_DIST_ACTIVITY_DATE Date of last activity on this record. DATE

NORTLBD

NORTLBD_ACTIVITY_DATE

NO

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

NOBTRAN

NOBTRAN_TRANSACTION_NO

NO

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

CONSTANT

'TBLD'

NO

NO
PAF_TRANSACTION_TYPE_DESC PAF transaction change type description. VARCHAR2(255)

FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255)FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE

NO

NO
PERCENT Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution. NUMBER

NORTLBD

NORTLBD_PERCENT

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

NORTLBD

NORTLBD_POSN

NO

NO
POSITION_TITLE Employee position description. Defaults from the position title if left blank. VARCHAR2(255)

FUNCTION

MPKFUNC.F_GET_EMPL_POSITION_INFO

NO

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

NA

NA

NO

NO
PROGRAM Program code where this APPROVAL TRANSACTION is charged. VARCHAR2(63)

NORTLBD

NORTLBD_PROG_CODE

NO

NO
PROGRAM_DESC Position program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

NO

NO
PROJECT Project code where this APPROVAL TRANSACTION is charged when cost accounting is used. VARCHAR2(63)

NORTLBD

NORTLBD_PROJ_CODE

NO

NO
PROJECT_DESC Position project description. VARCHAR2(255)

FTVPROJ

FTVPROJ_DESC

NO

NO


Ver: 9.2