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

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 deposited).
Recommended Search Columns CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, PERSON_UID
PERSON_UID

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BANK_ACCOUNT_NUMBER Bank Account Number The bank account number for the direct deposit. VARCHAR2(63)

PHRDOCM

PHRDOCM_BANK_ACCT_NO

BANK_ACCOUNT_TYPE Bank Account Type The type of account for direct deposit. VARCHAR2(63)

PHRDOCM

PHRDOCM_ACCT_TYPE

BANK_ACCOUNT_TYPE_DESC Bank Account Type Description Bank account type description. VARCHAR2(255)

PHRDOCM

PHRDOCM_ACCT_TYPE

BANK_ROUTING_NUMBER Bank Routing Number Specifies the bank routing number where the money is to be deposited. VARCHAR2(63)

PHRDOCM

PHRDOCM_BANK_CODE

BANK_ROUTING_NUMBER_DESC Bank Routing Number Description Bank name. VARCHAR2(255)

GXVDIRD

GXVDIRD_DESC

CALENDAR_YEAR Calendar Year The Calendar Year associated with the Payroll Identifier. VARCHAR2(63)

PHRDOCM

PHRDOCM_YEAR

DIRECT_DEPOSIT_IND Direct Deposit Indicator Indicates if the payroll event is a direct deposit. VARCHAR2(63)

CALCULATION

DECODE(PHRDOCM_DOC_TYPE)

DOCUMENT_DATE Document Date Date of the check or direct deposit notification. DATE

PHRDOCM

PHRDOCM_DOC_DATE

DOCUMENT_NET_AMOUNT Document Net Amount The amount of the check or direct deposit. NUMBER

PHRDOCM

PHRDOCM_NET

DOCUMENT_NUMBER Document Number The check or direct deposit notice number. VARCHAR2(63)

PHRDOCM

PHRDOCM_DOC_NO

EVENT_SEQUENCE_NUMBER Event Sequence Number Sequence of the pay event. NUMBER

PHRDOCM

PHRDOCM_SEQ_NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAYROLL_IDENTIFIER Payroll Identifier Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

PHRDOCM

PHRDOCM_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll Identifier Description Payroll code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

PHRDOCM

PHRDOCM_PAYNO

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

PHRDOCM

PHRDOCM_PIDM

PRIORITY Priority The sequence in which the documents are generated. NUMBER

PHRDOCM

PHRDOCM_PRIORITY

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RECONCILIATION Reconciliation Reconciliation status of the document. VARCHAR2(63)

PHRDOCM

PHRDOCM_RECON_IND

RECONCILIATION_DATE Reconciliation Date Bank statement reconciliation date. DATE

PHRDOCM

PHRDOCM_RECON_DATE

RECONCILIATION_DESC Reconciliation Description Reconciliation code description. VARCHAR2(255)

PHRDOCM

PHRDOCM_RECON_IND

REISSUED_IND Reissued Indicator Indicates if this document has been reissued. VARCHAR2(63)

PHRDOCM

PHRDOCM_REISSUE_IND



Ver: 9.2