Reporting View Target: PAYROLL

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 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

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 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.5

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
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	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