Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CURRENT_DATE	Current Date		DATE
DOMAIN_VALUE	Domain Value	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA
EARNINGS	Earnings	Identifies the transaction approval default earnings code.	VARCHAR2(3)		NORTERN	NORTERN_EARN_CODE
EARNINGS_DESC	Earnings Description	Earnings code long description.	VARCHAR2(30)		PTREARN	PTREARN_LONG_DESC
EARNINGS_END_DATE	Earnings End Date	Date on which this earnings code is canceled, ended or no longer applied to this position and job suffix for the person.	DATE		NORTERN	NORTERN_CANCEL_DATE
EARNINGS_HOURS	Earnings Hours		NUMBER
FEDERAL_EMPLOYMENT_HOURS	Federal Employment Hours	Hours for federal employment reporting. Used to report hours for Canadian Employment Insurance.	NUMBER		NORTERN	NORTERN_DEEMED_HRS
JOB_SUFFIX	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)		NORTERN	NORTERN_SUFF
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value		VARCHAR2(6)
PAF_APPLY_STATUS	Paf Apply Status	Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.	VARCHAR2(1)		NORTERN	NORTERN_APPLY_STATUS_IND
PAF_APPROVAL_TYPE	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)		NORTERN	NORTERN_APTY_CODE
PAF_APPROVAL_TYPE_DESC	Paf Approval Type Description	Approval type description.	VARCHAR2(30)		NTVAPTY	NTVAPTY_DESC
PAF_EARNING_ACTIVITY_DATE	Paf Earning Activity Date	Date of last activity on this record.	DATE		NORTERN	NORTERN_ACTIVITY_DATE
PAF_EFFECTIVE_DATE	Paf Effective Date	Date the personnel action record became effective.	DATE		NORTERN	NORTERN_EFFECTIVE_DATE
PAF_TRANSACTION_NUMBER	Paf Transaction Number	System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.	NUMBER		NORTERN	NORTERN_TRANSACTION_NO
PAF_TRANSACTION_TYPE	Paf Transaction Type	Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.	CHAR(4)		CALCULATION	EARN
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		NOBTRAN	NOBTRAN_PIDM
POSITION	Position	Position number attached to the personnel action.	VARCHAR2(6)		NORTERN	NORTERN_POSN
SHIFT_NUMBER	Shift Number	Shift associated with earnings code.	VARCHAR2(1)		NORTERN	NORTERN_SHIFT
SPECIAL_RATE	Special Rate	Special rate (if applicable) to be used for this earnings code.	NUMBER		NORTERN	NORTERN_SPECIAL_RATE
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: