Composite View Target: AP_PAYROLL

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_PAYROLL_DOCUMENT

Description Contains payroll document (check and direct deposit) information specific to each payroll.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

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

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

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

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

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

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

CURRENT_DATE Current Date DATE

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

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

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

DOMAIN_VALUE Domain Value Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

EVENT_SEQUENCE_NUMBER Event Sequence Number Sequence of the pay event. NUMBER(2)

MIF_DESC MIF Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

MIF_VALUE MIF Value Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NET_AMOUNT Net Amount The amount of the check or direct deposit. NUMBER(11, 2)

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

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

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

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

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

RECONCILIATION Reconciliation Reconciliation code that specifies whether or not the document has been reconciled. VARCHAR2(1)

RECONCILIATION_DATE Reconciliation Date The date from the bank statement on which the check was reconciled. DATE

RECONCILIATION_DESC Reconciliation Description Reconciliation code description. VARCHAR2(30)

REISSUED_IND Reissued Indicator Indicates if this document should be reissued. VARCHAR2(1)

ZONE_VALUE Zone Value Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

Ver:

Target Column	Business Name	Business Definition	Database Data Type
BANK_ACCOUNT_NUMBER	Bank Account Number	The bank account number for the direct deposit.	VARCHAR2(17)
BANK_ACCOUNT_TYPE	Bank Account Type	The type of account for direct deposit.	VARCHAR2(1)
BANK_ACCOUNT_TYPE_DESC	Bank Account Type Description	Bank account type description.	VARCHAR2(30)
BANK_ROUTING_NUMBER	Bank Routing Number	Specifies the bank routing number where the money is to be deposited.	VARCHAR2(9)
BANK_ROUTING_NUMBER_DESC	Bank Routing Number Description	Bank name.	VARCHAR2(30)
CALENDAR_YEAR	Calendar Year	The Calendar Year associated with the Payroll Identifier	VARCHAR2(4)
CURRENT_DATE	Current Date		DATE
DIRECT_DEPOSIT_IND	Direct Deposit Indicator	Indicates if the payroll event is a direct deposit.	VARCHAR2(1)
DOCUMENT_DATE	Document Date	Date of the check or direct deposit notification.	DATE
DOCUMENT_NUMBER	Document Number	The check or direct deposit notice number.	VARCHAR2(9)
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)
EVENT_SEQUENCE_NUMBER	Event Sequence Number	Sequence of the pay event.	NUMBER(2)
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)
NET_AMOUNT	Net Amount	The amount of the check or direct deposit.	NUMBER(11, 2)
PAYROLL_IDENTIFIER	Payroll Identifier	Pay identification number to which this Employee_Position belongs.	VARCHAR2(2)
PAYROLL_IDENTIFIER_DESC	Payroll Identifier Description	Payroll code description or title.	VARCHAR2(30)
PAYROLL_NUMBER	Payroll Number	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER(3)
PERSON_UID	Person UID	System generated unique internal identification number assigned to this person.	NUMBER(8)
PRIORITY	Priority	The sequence in which the documents are generated.	NUMBER(2)
RECONCILIATION	Reconciliation	Reconciliation code that specifies whether or not the document has been reconciled.	VARCHAR2(1)
RECONCILIATION_DATE	Reconciliation Date	The date from the bank statement on which the check was reconciled.	DATE
RECONCILIATION_DESC	Reconciliation Description	Reconciliation code description.	VARCHAR2(30)
REISSUED_IND	Reissued Indicator	Indicates if this document should be reissued.	VARCHAR2(1)
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)