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 Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

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

PHRDOCM

PHRDOCM_BANK_ACCT_NO

NO

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

PHRDOCM

PHRDOCM_ACCT_TYPE

NO

NO
BANK_ACCOUNT_TYPE_DESC Bank account type description. VARCHAR2(255)

PHRDOCM

PHRDOCM_ACCT_TYPE

NO

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

PHRDOCM

PHRDOCM_BANK_CODE

NO

NO
BANK_ROUTING_NUMBER_DESC Bank name. VARCHAR2(255)

GXVDIRD

GXVDIRD_DESC

NO

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

PHRDOCM

PHRDOCM_YEAR

NO

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

CALCULATION

DECODE(PHRDOCM_DOC_TYPE)

NO

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

PHRDOCM

PHRDOCM_DOC_DATE

NO

NO
DOCUMENT_NET_AMOUNT The amount of the check or direct deposit. NUMBER

PHRDOCM

PHRDOCM_NET

NO

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

PHRDOCM

PHRDOCM_DOC_NO

NO

NO
EVENT_SEQUENCE_NUMBER Sequence of the pay event. NUMBER

PHRDOCM

PHRDOCM_SEQ_NO

NO

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

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

PHRDOCM

PHRDOCM_PICT_CODE

NO

NO
PAYROLL_IDENTIFIER_DESC Payroll code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

PHRDOCM

PHRDOCM_PAYNO

NO

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

PHRDOCM

PHRDOCM_PIDM

NO

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

PHRDOCM

PHRDOCM_PRIORITY

NO

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

NA

NA

NO

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

PHRDOCM

PHRDOCM_RECON_IND

NO

NO
RECONCILIATION_DATE Bank statement reconciliation date. DATE

PHRDOCM

PHRDOCM_RECON_DATE

NO

NO
RECONCILIATION_DESC Reconciliation code description. VARCHAR2(255)

PHRDOCM

PHRDOCM_RECON_IND

NO

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

PHRDOCM

PHRDOCM_REISSUE_IND

NO

NO


Ver: 9.2