Go To View:  RETURN TO REPORTING VIEW 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

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

NA

NA

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

PHRDOCM

PHRDOCM_BANK_ACCT_NO

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

PHRDOCM

PHRDOCM_ACCT_TYPE

BANK_ACCOUNT_TYPE_DESC Bank account type description. VARCHAR2(255)

PHRDOCM

PHRDOCM_ACCT_TYPE

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 name. VARCHAR2(255)

GXVDIRD

GXVDIRD_DESC

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

PHRDOCM

PHRDOCM_YEAR

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

CALCULATION

DECODE(PHRDOCM_DOC_TYPE)

DOCUMENT_DATE Date of the check or direct deposit notification. DATE

PHRDOCM

PHRDOCM_DOC_DATE

DOCUMENT_NET_AMOUNT The amount of the check or direct deposit. NUMBER

PHRDOCM

PHRDOCM_NET

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

PHRDOCM

PHRDOCM_DOC_NO

EVENT_SEQUENCE_NUMBER Sequence of the pay event. NUMBER

PHRDOCM

PHRDOCM_SEQ_NO

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 Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

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

NA

NA

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 Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

PHRDOCM

PHRDOCM_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

PHRDOCM

PHRDOCM_PAYNO

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

PHRDOCM

PHRDOCM_PIDM

PRIORITY The sequence in which the documents are generated. NUMBER

PHRDOCM

PHRDOCM_PRIORITY

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

NA

NA

RECONCILIATION Reconciliation status of the document. VARCHAR2(63)

PHRDOCM

PHRDOCM_RECON_IND

RECONCILIATION_DATE Bank statement reconciliation date. DATE

PHRDOCM

PHRDOCM_RECON_DATE

RECONCILIATION_DESC Reconciliation code description. VARCHAR2(255)

PHRDOCM

PHRDOCM_RECON_IND

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

PHRDOCM

PHRDOCM_REISSUE_IND



Ver: 8.0