Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PAYROLL_DOCUMENT

Description Contains payroll document (check and direct deposit) information specific to each payroll.
Key & Frequency One row per payroll identifier per calendar year per payroll number per event sequence number per person. (In cases where a direct deposit is split amongst two or more accounts, a unique row would be created for each bank account number to which pay is depositied).
Recommended Search Columns CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, PERSON_UID
PERSON_UID

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
BANK_ACCOUNT_NUMBER The bank account number for the direct deposit.    

PHRDOCM

PHRDOCM_BANK_ACCT_NO

 
BANK_ACCOUNT_TYPE The type of account for direct deposit.    

PHRDOCM

PHRDOCM_ACCT_TYPE

 
BANK_ACCOUNT_TYPE_DESC Bank account type description.    

PHRDOCM

PHRDOCM_ACCT_TYPE

 
BANK_ROUTING_NUMBER Specifies the bank routing number where the money is to be deposited.    

PHRDOCM

PHRDOCM_BANK_CODE

 
BANK_ROUTING_NUMBER_DESC Bank name.    

GXVDIRD

GXVDIRD_DESC

 
CALENDAR_YEAR The Calendar Year associated with the Payroll Identifier    

PHRDOCM

PHRDOCM_YEAR

 
DIRECT_DEPOSIT_IND Indicates if the payroll event is a direct deposit.    

CALCULATION

DECODE(PHRDOCM_DOC_TYPE)

 
DOCUMENT_DATE Date of the check or direct deposit notification.    

PHRDOCM

PHRDOCM_DOC_DATE

 
DOCUMENT_NET_AMOUNT The amount of the check or direct deposit.    

PHRDOCM

PHRDOCM_NET

 
DOCUMENT_NUMBER The check or direct deposit notice number.    

PHRDOCM

PHRDOCM_DOC_NO

 
EVENT_SEQUENCE_NUMBER Sequence of the pay event.    

PHRDOCM

PHRDOCM_SEQ_NO

 
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME Combination of the person's first, middle initial, and last name into one value.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs.    

PHRDOCM

PHRDOCM_PICT_CODE

 
PAYROLL_IDENTIFIER_DESC Payroll code description or title.    

FUNCTION

GOKODSF.F_GET_DESC

 
PAYROLL_NUMBER The Pay Number is used to uniquely identify a pay period within a fiscal year.    

PHRDOCM

PHRDOCM_PAYNO

 
PERSON_UID System generated unique internal identification number assigned to this person.    

PHRDOCM

PHRDOCM_PIDM

 
PRIORITY The sequence in which the documents are generated.    

PHRDOCM

PHRDOCM_PRIORITY

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
RECONCILIATION Reconciliation status of the document.    

PHRDOCM

PHRDOCM_RECON_IND

 
RECONCILIATION_DATE Bank statement reconciliation date.    

PHRDOCM

PHRDOCM_RECON_DATE

 
RECONCILIATION_DESC Reconciliation code description.    

PHRDOCM

PHRDOCM_RECON_IND

 
REISSUED_IND Indicates if this document has been reissued.    

PHRDOCM

PHRDOCM_REISSUE_IND

 


Ver: 8.3