Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACCOUNT
|
Account code that this APPROVAL TRANSACTION was charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_ACCT_CODE
|
ACCOUNT_DESC
|
Position account description.
|
VARCHAR2(35)
|
FTVACCT
|
FTVACCT_TITLE
|
ACCOUNT_INDEX
|
Account index code that was used to default the account distribution this APPROVAL TRANSACTION was charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_ACCI_CODE
|
ACCOUNT_INDEX_DESC
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(35)
|
FTVACCI
|
FTVACCI_TITLE
|
ACTIVITY
|
Activity code where this APPROVAL TRANSACTION is charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_ACTV_CODE
|
ACTIVITY_DESC
|
Position activity description.
|
VARCHAR2(35)
|
FTVACTV
|
FTVACTV_TITLE
|
CHART_OF_ACCOUNTS
|
Chart of accounts code where this APPROVAL TRANSACTION is charged.
|
VARCHAR2(1)
|
NORTBLD
|
NORTLBD_COAS_CODE
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COST_TYPE
|
Cost type where this APPROVAL TRANSACTION is charged when cost accounting is used.
|
VARCHAR2(2)
|
NORTBLD
|
NORTLBD_CTYP_CODE
|
COST_TYPE_LONG_DESC
|
|
VARCHAR2(30)
|
|
|
COST_TYPE_SHORT_DESC
|
|
VARCHAR2(30)
|
|
|
CURRENT_DATE
|
|
DATE
|
|
|
DOMAIN_VALUE
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
ENCUMBRANCE_CALCULATE_END_DATE
|
End date used to calculate future fiscal year encumbrances for a labor distribution.
|
DATE
|
NORTBLD
|
NORTLBD_ENC_OVERRIDE_END_DATE
|
EXTERNAL_ACCOUNT
|
Free form account number to be used to interface to an external finance system.
|
VARCHAR2(60)
|
NORTBLD
|
NORTLBD_ACCT_CODE_EXTERNAL
|
FUND
|
Fund code where this APPROVAL TRANSACTION is charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_FUND_CODE
|
FUND_DESC
|
Position fund description.
|
VARCHAR2(35)
|
FTVFUND
|
FTVFUND_TITLE
|
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)
|
NORTBLD
|
NORTBLD_SUFF
|
LOCATION
|
Location code where this APPROVAL TRANSACTION is charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_LOCN_CODE
|
LOCATION_DESC
|
Position location description.
|
VARCHAR2(35)
|
FTVLOCN
|
FTVLOCN_TITLE
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
ORGANIZATION
|
Organization code where this APPROVAL TRANSACTION is charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_ORGN_CODE
|
ORGANIZATION_CODE
|
|
VARCHAR2(6)
|
|
|
ORGANIZATION_DESC
|
Position organization description.
|
VARCHAR2(35)
|
FTVORGN
|
FTVORGN_TITLE
|
PAF_APPLY_STATUS
|
Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.
|
VARCHAR2(1)
|
NORTBLD
|
NORTLBD_APPLY_STATUS_IND
|
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)
|
NORTBLD
|
NORTBLD_APTY_CODE
|
PAF_APPROVAL_TYPE_DESC
|
Approval type description.
|
VARCHAR2(30)
|
NTVAPTY
|
NTVAPTY_DESC
|
PAF_EFFECTIVE_DATE
|
Date the personnel action record became effective.
|
DATE
|
NORTBLD
|
NORTLBD_EFFECTIVE_DATE
|
PAF_LABOR_DIST_ACTIVITY_DATE
|
Date of last activity on this record.
|
DATE
|
NORTBLD
|
NORTLBD_ACTIVITY_DATE
|
PAF_TRANSACTION_NUMBER
|
System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.
|
NUMBER
|
NORTBLD
|
NORTLBD_TRANSACTION_NO
|
PAF_TRANSACTION_TYPE
|
Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.
|
CHAR(4)
|
CALCULATION
|
TBLD
|
PERCENT
|
Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
|
NUMBER
|
NORTBLD
|
NORTLBD_PERCENT
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_PIDM
|
POSITION
|
Position number attached to the personnel action.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_POSN
|
PROGRAM
|
Program code where this APPROVAL TRANSACTION is charged.
|
VARCHAR2(6)
|
NORTBLD
|
NORTLBD_PROG_CODE
|
PROGRAM_DESC
|
Position program description.
|
VARCHAR2(35)
|
FTVPROG
|
FTVPROG_TITLE
|
PROJECT
|
Project code where this APPROVAL TRANSACTION is charged when cost accounting is used.
|
VARCHAR2(8)
|
NORTBLD
|
NORTLBD_PROJ_CODE
|
PROJECT_DESC
|
Position project description.
|
VARCHAR2(30)
|
FTVPROJ
|
FTVPROJ_DESC
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|