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
|