Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
CURRENT_DATE
|
|
DATE
|
|
|
|
NO
|
DOMAIN_VALUE
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
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(2)
|
NORTRAN
|
NORTRAN_SUFF
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PAF_APPLY_ACTIVITY_DATE
|
Date of last activity on this record.
|
DATE
|
NORTRAN
|
NORTRAN_ACTIVITY_DATE
|
NO
|
NO
|
PAF_APPLY_COLUMN
|
Database column that was sent through the approval process.
|
VARCHAR2(30)
|
NORTRAN
|
NORTRAN_AUFD_CODE
|
NO
|
NO
|
PAF_APPLY_FORM
|
Data entry form that was sent through the approval process.
|
VARCHAR2(7)
|
NORTRAN
|
NORTRAN_AUFM_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
PAF_APPLY_STATUS_DESC
|
Personnel action sequence status description.
|
VARCHAR2(255)
|
FUNCTION
|
TBD
|
NO
|
NO
|
PAF_APPLY_TABLE
|
Database table that was sent through the approval process.
|
VARCHAR2(30)
|
NORTRAN
|
NORTRAN_AUBK_CODE
|
NO
|
NO
|
PAF_APPLY_VALUE
|
New value entered for the database column.
|
VARCHAR2(500)
|
NORTRAN
|
NORTRAN_VALUE
|
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(6)
|
NORTRAN
|
NORTRAN_APTY_CODE
|
NO
|
NO
|
PAF_APPROVAL_TYPE_DESC
|
Approval type description.
|
VARCHAR2(30)
|
NTVAPTY
|
NTVAPTY_DESC
|
NO
|
NO
|
PAF_SEQUENCE_NUMBER
|
Display sequence for each of field changed in the approval transaction.
|
NUMBER
|
NORTRAN
|
NORTRAN_DISPLAY_SEQ_NO
|
NO
|
NO
|
PAF_TRANSACTION_NUMBER
|
System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.
|
NUMBER
|
NORTRAN
|
NORTRAN_TRANSACTION_NO
|
NO
|
NO
|
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'
|
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(6)
|
NORTRAN
|
NORTRAN_POSN
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|