Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: NOBTRAN Human Resources
SGHE Banner Operational Data Store Composite View Source: NOBTRAN - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
NOBTRAN_ACAT_CODE NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_APPROVAL_CATEGORY

 
NOBTRAN_ACTIVITY_DATE NOAEPAF        
NOBTRAN_APPLY_DATE NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_APPLY_DATE

 
NOBTRAN_APPLY_IND NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_APPLY_IND

 
NOBTRAN_APPLY_USER_ID NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_APPLY_USER_ID

 
NOBTRAN_CREATED_DATE NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_ORIGINATOR_CREATE_DATE

 
NOBTRAN_EFFECTIVE_DATE NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_EFFECTIVE_DATE

 
NOBTRAN_ORIGINATOR_USER_ID NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_ORIGINATOR_USER_ID

 
NOBTRAN_PIDM NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION_EARNING

AN_PERSONNEL_ACTION_GENERAL

AN_PERSONNEL_ACTION

AN_PERSONNEL_ACTION_LABOR_DIST

PERSON_UID

PERSON_UID

PERSON_UID

PERSON_UID

 
NOBTRAN_SUBMISSION_DATE NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_SUBMIT_DATE

 
NOBTRAN_SUBMITTOR_USER_ID NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_SUBMIT_USER_ID

 
NOBTRAN_TRANSACTION_NO NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_TRANSACTION_NUMBER

 
NOBTRAN_TRANS_STATUS_IND NOAEPAF COMPOSITE VIEW

AN_PERSONNEL_ACTION

PAF_TRANSACTION_STATUS

 


Ver: