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
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)		NORTRAN	NORTRAN_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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PAF_APPLY_ACTIVITY_DATE	Paf Apply Activity Date	Date of last activity on this record.	DATE		NORTRAN	NORTRAN_ACTIVITY_DATE
PAF_APPLY_COLUMN	Paf Apply Column	Database column that was sent through the approval process.	VARCHAR2(30)		NORTRAN	NORTRAN_AUFD_CODE
PAF_APPLY_FORM	Paf Apply Form	Data entry form that was sent through the approval process.	VARCHAR2(7)		NORTRAN	NORTRAN_AUFM_CODE
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)		NORTRAN	NORTRAN_APPLY_STATUS_IND
PAF_APPLY_STATUS_DESC	Paf Apply Status Description	Personnel action sequence status description.	VARCHAR2(255)		FUNCTION	TBD
PAF_APPLY_TABLE	Paf Apply Table	Database table that was sent through the approval process.	VARCHAR2(30)		NORTRAN	NORTRAN_AUBK_CODE
PAF_APPLY_VALUE	Paf Apply Value	New value entered for the database column.	VARCHAR2(500)		NORTRAN	NORTRAN_VALUE
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)		NORTRAN	NORTRAN_APTY_CODE
PAF_APPROVAL_TYPE_DESC	Paf Approval Type Description	Approval type description.	VARCHAR2(30)		NTVAPTY	NTVAPTY_DESC
PAF_SEQUENCE_NUMBER	Paf Sequence Number	Display sequence for each of field changed in the approval transaction.	NUMBER		NORTRAN	NORTRAN_DISPLAY_SEQ_NO
PAF_TRANSACTION_NUMBER	Paf Transaction Number	System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.	NUMBER		NORTRAN	NORTRAN_TRANSACTION_NO
PAF_TRANSACTION_TYPE	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'
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)		NORTRAN	NORTRAN_POSN
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: