GTVCURR GURCURR GXRDIRD GXVBANK GXVDIRD PEBPAYM PHRDOCM PHRHIST STVNATN AF_ACCTG_DISTRIBUTION_ANALYSIS AF_DISBURSEMENT_ANALYSIS FIVCASH

Model Banking_and_Currency


Model Label :

List of Objects

Object Name Object Type Layer Name
AF_ACCTG_DISTRIBUTION_ANALYSIS SQL View Default
AF_DISBURSEMENT_ANALYSIS SQL View Default
FIVCASH SQL View Default
GTVCURR SQL Table Default
GURCURR SQL Table Default
GXRDIRD SQL Table Default
GXVBANK SQL Table Default
GXVDIRD SQL Table Default
PEBPAYM SQL Table Default
PHRDOCM SQL Table Default
PHRHIST SQL Table Default
STVNATN SQL Table Default

Model View

Table GTVCURR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVCURR_CURR_CODE   VARCHAR2(4) No *  
GTVCURR_RATE_EFF_DATE   DATE No *  
GTVCURR_ACTIVITY_DATE   DATE No    
GTVCURR_USER_ID   VARCHAR2(30) No    
GTVCURR_RATE_NCHG_DATE   DATE No *  
GTVCURR_RATE_TERM_DATE   DATE Yes    
GTVCURR_TITLE   VARCHAR2(35) No    
GTVCURR_STATUS_IND   VARCHAR2(1) No    
GTVCURR_AP_ACCT   VARCHAR2(6) Yes    
GTVCURR_NATION_CODE   VARCHAR2(5) Yes   *
GTVCURR_CONV_TYPE   VARCHAR2(1) Yes    
GTVCURR_EXCH_ACCT   VARCHAR2(6) Yes    
GTVCURR_BANK_CODE   VARCHAR2(2) Yes    
GTVCURR_DISB_AGENT_PIDM   NUMBER(8,0) Yes    
GTVCURR_AP_ACCT2   VARCHAR2(60) Yes    
GTVCURR_EXCH_ACCT2   VARCHAR2(60) Yes    
GTVCURR_SCOD_CODE_ISO   VARCHAR2(3) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
GTVCURR_NATION_CODE STVNATN_CODE STVNATN

Index

Index Name Index Type Column Name
PK_GTVCURR Unique GTVCURR_CURR_CODE
PK_GTVCURR Unique GTVCURR_RATE_EFF_DATE
PK_GTVCURR Unique GTVCURR_RATE_NCHG_DATE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVCURR_ADD SQL View S10B80.BANINST1 Use (select)
GTVCURR_ADS SQL View S10B80.BANINST1 Use (select)
ABAL_RECTYPE Oracle Package Type S10B80.BANINST1.FOKUTIL Rely On
CURRENCY_REC Oracle Package Type S10B80.BANINST1.GB_CURRENCY Rely On
P_VALIDATE_CURRENCY Oracle Package Procedure S10B80.BANINST1.FB_INVOICE_HEADER_RULES Rely On
GETCURRRATERECC Oracle Package Cursor S10B80.BANINST1.BWFKRPCU Rely On
GETCURRRATERECC Oracle Package Cursor S10B80.BANINST1.BWFKRPCU Use (select)
GETCURRRECC Oracle Package Cursor S10B80.BANINST1.BWFKRPCU Rely On
GETCURRRECC Oracle Package Cursor S10B80.BANINST1.BWFKRPCU Use (select)Rely On
GTVCURR_C Oracle Package Cursor S10B80.BANINST1.GB_GTVCURR Rely On
GTVCURR_C Oracle Package Cursor S10B80.BANINST1.GB_GTVCURR Use (select)Rely On
P_IS_FOAP_POSTABLE Oracle Package Procedure S10B80.BANINST1.FOKUTIL Rely On
P_LOOKUP Oracle Package Procedure S10B80.BANINST1.BWFKPROC Rely On
P_LOOKUP Oracle Package Procedure S10B80.BANINST1.BWFKPROC Use (select)
P_PURCHASEORDER Oracle Package Procedure S10B80.BANINST1.BWFKPURR Rely On
P_PURCHASEORDER Oracle Package Procedure S10B80.BANINST1.BWFKPURR Use (select)Rely On
P_REQUISITION Oracle Package Procedure S10B80.BANINST1.BWFKREQN Rely On
P_REQUISITION Oracle Package Procedure S10B80.BANINST1.BWFKREQN Use (select)Rely On
P_VALIDATE_HEADER Oracle Package Procedure S10B80.BANINST1.FPKREQN Rely On
P_VALIDATE_HEADER Oracle Package Procedure S10B80.BANINST1.FPKPURR Rely On
P_VIEWINV Oracle Package Procedure S10B80.BANINST1.BWFKVINV Rely On
P_VIEWPUR Oracle Package Procedure S10B80.BANINST1.BWFKVPUR Rely On
P_VIEWREQ Oracle Package Procedure S10B80.BANINST1.BWFKVREQ Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TB_RECEIVABLE Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TP_STUDENT_DEPOSIT Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TP_STUDENT_RECEIVABLE Use (Insert)
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.GB_GTVCURR Rely On
F_CODE_EXISTS_ACTIVE Oracle Package Function S10B80.BANINST1.GB_CURRENCY Rely On
F_DISB_AGENT_EXIST Oracle Package Function S10B80.BANINST1.FOKUTIL Use (select)
F_EXISTS Oracle Package Function S10B80.BANINST1.GB_CURRENCY Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.GB_CURRENCY Use (select)
F_GET_CURR_DESC Oracle Package Function S10B80.BANINST1.BWFKVDOC Rely On
F_GET_CURR_DESC Oracle Package Function S10B80.BANINST1.BWFKVDOC Use (select)
F_GET_CURR_DESC Oracle Package Function S10B80.BANINST1.BWFKVINV Rely On
F_GET_CURR_DESC Oracle Package Function S10B80.BANINST1.BWFKVINV Use (select)
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.GB_GTVCURR Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.GB_CURRENCY Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.GB_CURRENCY Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.GB_CURRENCY Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.GB_CURRENCY Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.GB_CURRENCY Use (select)
GTVCURR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVCURR SQL Index S10B80.GENERAL Rely On
STVNATN SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVCURR

Object Dates

Creation Date Analysis Date
04/02/2008 20:31:32:000 04/02/2008 21:17:55:000

Source Code Comments

Currency conversion validation table.

Columns Comments for GTVCURR_CURR_CODE (# 1)

Source Code Comments

CURRENCY CODE: A code which uniquely identifies a type of currency.

Columns Comments for GTVCURR_RATE_EFF_DATE (# 2)

Source Code Comments

EFFECTIVE DATE: The effective date of this particular record.

Columns Comments for GTVCURR_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date that information for this record on the table was entered or last updated.

Columns Comments for GTVCURR_USER_ID (# 4)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Columns Comments for GTVCURR_RATE_NCHG_DATE (# 5)

Source Code Comments

NEXT CHANGE DATE: The change date for this particular record. I.E., if the record included a termination date, the next change date would reflect the date that the termination date was entered. Requires at future change record.

Columns Comments for GTVCURR_RATE_TERM_DATE (# 6)

Source Code Comments

TERMINATION DATE: The date when this particular record is no longer in effect.

Columns Comments for GTVCURR_TITLE (# 7)

Source Code Comments

TITLE: The description or title for this currency code.

Columns Comments for GTVCURR_STATUS_IND (# 8)

Source Code Comments

STATUS INDICATOR: The current status of the associated validation table record.

Columns Comments for GTVCURR_AP_ACCT (# 9)

Source Code Comments

ACCOUNTS PAYABLE ACCOUNT: Identifies the accounts payable account code to be used if an entity intends to produce a check in a foreign currency rather than through a disbursing agent.

Columns Comments for GTVCURR_NATION_CODE (# 10)

Source Code Comments

NATION CODE: Identifies the nation code associated with this currency code.

Columns Comments for GTVCURR_CONV_TYPE (# 11)

Source Code Comments

CONVERSION TYPE: Identifies the type of conversion rate for this currency code. Type may be daily or periodic.

Columns Comments for GTVCURR_EXCH_ACCT (# 12)

Source Code Comments

EXCHANGE ACCOUNT: Identifies the account code to be used when foreign currency checks are run and contains the difference between the calculated exchange and invoice amount at base currency.

Columns Comments for GTVCURR_BANK_CODE (# 13)

Source Code Comments

BANK CODE: Identifies the bank code to be defaulted when a foreign currency is used to post an invoice.

Columns Comments for GTVCURR_DISB_AGENT_PIDM (# 14)

Source Code Comments

DISBURSING AGENT PIDM: Personal identifcation number used when an entity intends to produce a check in base currency with directions to a third party to produce the foreign currency check.

Columns Comments for GTVCURR_AP_ACCT2 (# 15)

Source Code Comments

Accounts Payable account related to currency conversion for clients who do not have Banner Finance.

Columns Comments for GTVCURR_EXCH_ACCT2 (# 16)

Source Code Comments

Exchange account related to currency conversion for clients who do not have Banner Finance.

Columns Comments for GTVCURR_SCOD_CODE_ISO (# 17)

Source Code Comments

ISO CODE: The three character International Standards Organization (ISO) Standard Code associated with the user defined currency code.

Table GURCURR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GURCURR_CURR_CODE   VARCHAR2(4) No *  
GURCURR_CONV_RATE   NUMBER(17,7) No    
GURCURR_RATE_EFF_DATE   DATE No *  
GURCURR_RATE_NCHG_DATE   DATE No *  
GURCURR_ACTIVITY_DATE   DATE No    
GURCURR_USER_ID   VARCHAR2(30) No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GURCURR Unique GURCURR_CURR_CODE
PK_GURCURR Unique GURCURR_RATE_EFF_DATE
PK_GURCURR Unique GURCURR_RATE_NCHG_DATE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GURCURR_ADS SQL View S10B80.BANINST1 Use (select)
GURCURR_SUB SQL View S10B80.BANINST1 Use (select)
CURRENCY_RATE_REC Oracle Package Type S10B80.BANINST1.GB_CURRENCY_RATE Rely On
GETCURRRATERECC Oracle Package Cursor S10B80.BANINST1.BWFKRPCU Use (select)Rely On
P_EDIT_CALC Oracle Package Procedure S10B80.BANINST1.GB_CURRENCY_RATE Rely On
P_PURCHASEORDER Oracle Package Procedure S10B80.BANINST1.BWFKPURR Rely On
P_REQUISITION Oracle Package Procedure S10B80.BANINST1.BWFKREQN Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TB_RECEIVABLE Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TP_STUDENT_DEPOSIT Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TP_STUDENT_RECEIVABLE Use (Insert)
F_CONVERTED_AMOUNT Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Use (select)
F_GET_CURRENCY_RATE Oracle Package Function S10B80.BANINST1.FOKUTIL Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.GB_CURRENCY_RATE Use (select)
GURCURR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GURCURR SQL Index S10B80.GENERAL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURCURR

Object Dates

Creation Date Analysis Date
04/02/2008 20:29:44:000 04/02/2008 21:17:53:000

Source Code Comments

Currency conversion rate table.

Columns Comments for GURCURR_CURR_CODE (# 1)

Source Code Comments

CURRENCY CODE: A code which uniquely identifies the type of currency for which these conversion rates apply.

Columns Comments for GURCURR_CONV_RATE (# 2)

Source Code Comments

CONVERSION RATE: The conversion rate to base currency amount.

Columns Comments for GURCURR_RATE_EFF_DATE (# 3)

Source Code Comments

EFFECTIVE DATE: The effective date of this particular conversion rate.

Columns Comments for GURCURR_RATE_NCHG_DATE (# 4)

Source Code Comments

EFFECTIVE DATE: The effective date of the next conversion rate.

Columns Comments for GURCURR_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that information for this record on the table was entered or last updated.

Columns Comments for GURCURR_USER_ID (# 6)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Table GXRDIRD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXRDIRD_PIDM   NUMBER(8,0) No    
GXRDIRD_STATUS   VARCHAR2(1) No    
GXRDIRD_DOC_TYPE   VARCHAR2(1) No    
GXRDIRD_PRIORITY   NUMBER(2,0) No    
GXRDIRD_AP_IND   VARCHAR2(1) No    
GXRDIRD_HR_IND   VARCHAR2(1) No    
GXRDIRD_ACTIVITY_DATE   DATE No    
GXRDIRD_USER_ID   VARCHAR2(30) No    
GXRDIRD_BANK_ACCT_NUM   VARCHAR2(17) Yes    
GXRDIRD_BANK_ROUT_NUM   VARCHAR2(9) Yes   *
GXRDIRD_AMOUNT   NUMBER(17,2) Yes    
GXRDIRD_PERCENT   NUMBER(5,2) Yes    
GXRDIRD_ACCT_TYPE   VARCHAR2(1) Yes    
GXRDIRD_ATYP_CODE   VARCHAR2(2) Yes    
GXRDIRD_ADDR_SEQNO   NUMBER(2,0) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
GXRDIRD_BANK_ROUT_NUM GXVDIRD_CODE_BANK_ROUT_NUM GXVDIRD

Index

Index Name Index Type Column Name
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_PIDM
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_BANK_ROUT_NUM
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_BANK_ACCT_NUM
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_PRIORITY
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_DOC_TYPE
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_ATYP_CODE
GXRDIRD_KEY_INDEX1 Unique GXRDIRD_ADDR_SEQNO
GXRDIRD_KEY_INDEX2 Unique GXRDIRD_PIDM
GXRDIRD_KEY_INDEX2 Unique GXRDIRD_PRIORITY
GXRDIRD_KEY_INDEX2 Unique GXRDIRD_ATYP_CODE
GXRDIRD_KEY_INDEX2 Unique GXRDIRD_ADDR_SEQNO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GXRDIRD_TYPE Oracle Package Type S10B80.BANINST1.BWPKHPAY Rely On
COUNT_GXRDIRD Oracle Package Cursor S10B80.BANINST1.BWPKHPAY Use (select)
PERCENT100_EXISTS_C Oracle Package Cursor S10B80.BANINST1.BWPKHPAY Use (select)
PRIORITYLISTC Oracle Package Cursor S10B80.BANINST1.BWPKHPAY Use (select)
P_CHK_REMAINING_LAST Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
PRIORITY_REC Oracle Package Variable S10B80.BANINST1.BWPKHPAY Rely On
GXRDIRDC Oracle Package Cursor S10B80.BANINST1.PHKLIBS Use (select)Rely On
GXRDIRD_PRENOTEC Oracle Package Cursor S10B80.BANINST1.PHKLIBS Use (select)Rely On
P_CALCDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.PHKLIBS Rely On
P_FORMATDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.PHKLIBS Rely On
P_MODIFYDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
P_MODIFYINDIVDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (select)
P_UPDATEDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
P_UPDATEDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (Insert,update,delete,select)
P_UPDINDIVDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (update)
P_VALIDATE_DELETE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Use (select)
P_VIEWDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
F_GET_VENDOR_AP_ACH_STATUS Oracle Package Function S10B80.BANINST1.FB_COMMON Rely On
F_GET_VENDOR_AP_ACH_STATUS Oracle Package Function S10B80.BANINST1.FB_COMMON Use (select)
GXRDIRD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GXRDIRD_KEY_INDEX1 SQL Index S10B80.GENERAL Rely On
GXRDIRD_KEY_INDEX2 SQL Index S10B80.GENERAL Rely On
GXVDIRD SQL Table S10B80.GENERAL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GXRDIRD

Object Dates

Creation Date Analysis Date
04/02/2008 20:31:56:000 04/02/2008 21:17:56:000

Source Code Comments

Recipient Direct Deposit Information Table.

Columns Comments for GXRDIRD_PIDM (# 1)

Source Code Comments

GXRDIRD_PIDM: Personal Identification Number of the recipient as set in SPRIDEN.

Columns Comments for GXRDIRD_STATUS (# 2)

Source Code Comments

GXRDIRD_STATUS: Direct Deposit Status of recipient. (A)ctive, (I)nactive, (P)renote.

Columns Comments for GXRDIRD_DOC_TYPE (# 3)

Source Code Comments

GXRDIRD_DOC_TYPE: The document type - (C)heck or (D)irect Deposit.

Columns Comments for GXRDIRD_PRIORITY (# 4)

Source Code Comments

PRIORITY: The priority in which direct deposits are to be distributed.

Columns Comments for GXRDIRD_AP_IND (# 5)

Source Code Comments

ACCOUNTS PAYABLE INDICATOR: This indicator is to designate whether the bank information is (A)ctive for Finance direct deposits or (I)nactive for Finance direct deposits.

Columns Comments for GXRDIRD_HR_IND (# 6)

Source Code Comments

PAYROLL INDICATOR: This indicator is to designate whether the bank information is (A)ctive for Payroll direct deposits or (I)nactive for Payroll direct deposits.

Columns Comments for GXRDIRD_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: The date when the information for this record on the table was entered or last updated.

Columns Comments for GXRDIRD_USER_ID (# 8)

Source Code Comments

USER ID: The user id of the person who updates this record.

Columns Comments for GXRDIRD_BANK_ACCT_NUM (# 9)

Source Code Comments

BANK ACCOUNT NO: The account number of the recipients account.

Columns Comments for GXRDIRD_BANK_ROUT_NUM (# 10)

Source Code Comments

BANK ROUTING NO: The bank routing number of the recipients bank.

Columns Comments for GXRDIRD_AMOUNT (# 11)

Source Code Comments

AMOUNT: The amount of the direct deposit.

Columns Comments for GXRDIRD_PERCENT (# 12)

Source Code Comments

PERCENT: The percent of net to be direct deposited.

Columns Comments for GXRDIRD_ACCT_TYPE (# 13)

Source Code Comments

ACCOUNT TYPE: The type of account for direct deposit (checking or savings).

Columns Comments for GXRDIRD_ATYP_CODE (# 14)

Source Code Comments

ADDRESS TYPE CODE: The user defined code that describes the type of address, i.e., Purchase Order, Remit To, Mailing, etc. Must exist on SATURN.STVATYP.

Columns Comments for GXRDIRD_ADDR_SEQNO (# 15)

Source Code Comments

ADDRESS SEQUENCE NO: The address sequence number of the recipient.

Table GXVBANK

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXVBANK_BANK_CODE   VARCHAR2(2) No *  
GXVBANK_EFF_DATE   DATE No *  
GXVBANK_BANK_CODE_PIDM   NUMBER(8,0) No    
GXVBANK_ACCT_NUM   VARCHAR2(17) No    
GXVBANK_ACCT_NAME   VARCHAR2(35) No    
GXVBANK_ACH_STATUS   VARCHAR2(1) No    
GXVBANK_STATUS_IND   VARCHAR2(1) No    
GXVBANK_ACTIVITY_DATE   DATE No    
GXVBANK_USER_ID   VARCHAR2(30) No    
GXVBANK_NCHG_DATE   DATE No *  
GXVBANK_TERM_DATE   DATE Yes    
GXVBANK_COAS_CODE   VARCHAR2(1) Yes    
GXVBANK_ACCT_CODE_CASH   VARCHAR2(6) Yes    
GXVBANK_ACCT_CODE_INTERFUND   VARCHAR2(6) Yes    
GXVBANK_FUND_CODE   VARCHAR2(6) Yes    
GXVBANK_CURR_CODE   VARCHAR2(4) Yes    
GXVBANK_ACH_DEST_NO   VARCHAR2(10) Yes    
GXVBANK_ACH_ORIG_NO   VARCHAR2(10) Yes    
GXVBANK_ACH_DEST_NAME   VARCHAR2(23) Yes    
GXVBANK_ACH_SHORT_ORIG_NAME   VARCHAR2(15) Yes    
GXVBANK_COMPANY_TYPE   VARCHAR2(1) Yes    
GXVBANK_COMPANY_ID   VARCHAR2(9) Yes    
GXVBANK_ACH_ORIG_NAME   VARCHAR2(23) Yes    
GXVBANK_BANK_ROUT_NUM   VARCHAR2(9) Yes    
GXVBANK_ACH_FILE_NUMBER   NUMBER(4,0) Yes    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GXVBANK Unique GXVBANK_BANK_CODE
PK_GXVBANK Unique GXVBANK_EFF_DATE
PK_GXVBANK Unique GXVBANK_NCHG_DATE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AF_ACCTG_DISTRIBUTION_ANALYSIS SQL View S10B80.BANINST1 Use (select)
AF_DISBURSEMENT_ANALYSIS SQL View S10B80.BANINST1 Use (select)
FIVCASH SQL View S10B80.BANINST1 Use (select)
F_FINANCE_BANK_IND SQL Function S10B80.BANINST1 Use (select)
F_GET_GXVBANK_ROW SQL Function S10B80.BANINST1 Rely On
F_GET_GXVBANK_ROW SQL Function S10B80.BANINST1 Use (select)Rely On
FINANCE_RECTYPE Oracle Package Type S10B80.BANINST1.FB_COMMON Rely On
P_VALIDATE_DETAIL Oracle Package Procedure S10B80.BANINST1.FB_JV_DETAIL_RULES Rely On
P_CREATE_PCARD_INVOICES Oracle Package Procedure S10B80.BANINST1.FP_INVOICE Rely On
P_CREATE_REFUND_INVOICES Oracle Package Procedure S10B80.BANINST1.FP_INVOICE Rely On
P_EDIT_BANK_CODE Oracle Package Procedure S10B80.BANINST1.FFKFOAP Rely On
P_EDIT_BANK_CODE Oracle Package Procedure S10B80.BANINST1.FFKFOAP Use (select)
F_GET_CURR_FROM_BANK Oracle Package Function S10B80.BANINST1.FOKUTIL Use (select)
F_GXVBANK_EQUAL Oracle Package Function S10B80.BANINST1.FOKPVAL Use (select)
F_IS_BANK_CODE_VALID Oracle Package Function S10B80.BANINST1.FB_COMMON Rely On
F_IS_BANK_CODE_VALID Oracle Package Function S10B80.BANINST1.FB_COMMON Use (select)
F_TRNI_SEL_GXVBANK Oracle Package Function S10B80.BANINST1.BWFKED1T Use (select)
GXVBANK Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GXVBANK SQL Index S10B80.GENERAL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GXVBANK

Object Dates

Creation Date Analysis Date
04/02/2008 20:27:48:000 04/02/2008 21:17:51:000

Source Code Comments

Bank Validation Table

Columns Comments for GXVBANK_BANK_CODE (# 1)

Source Code Comments

BANK CODE: A user-defined value which is used for identification purposes on all transactions. All bank codes and other attributes are displayed on form GXVBANK.

Columns Comments for GXVBANK_EFF_DATE (# 2)

Source Code Comments

EFFECTIVE DATE: The effective date of this particular record.

Columns Comments for GXVBANK_BANK_CODE_PIDM (# 3)

Source Code Comments

Personal IDENTIFICATION NUMBER : PIDM as set in SPRIDEN.

Columns Comments for GXVBANK_ACCT_NUM (# 4)

Source Code Comments

BANK ACCOUNT NUMBER: This is the bank assigned number unique to this account and is the number that is encoded on the checks.

Columns Comments for GXVBANK_ACCT_NAME (# 5)

Source Code Comments

BANK ACCOUNT NAME: The name of the banking institution where the installlment has accounts.

Columns Comments for GXVBANK_ACH_STATUS (# 6)

Source Code Comments

DIRECT DEPOSIT STATUS : Indicator whether bank does direct deposit payments, (A)ctive and (I)nactive.

Columns Comments for GXVBANK_STATUS_IND (# 7)

Source Code Comments

STATUS INDICATOR: The current status of the associated validation table record.

Columns Comments for GXVBANK_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: The date when the information for this record on the table was entered or last updated.

Columns Comments for GXVBANK_USER_ID (# 9)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Columns Comments for GXVBANK_NCHG_DATE (# 10)

Source Code Comments

NEXT CHANGE DATE: The change date for this particular record.

Columns Comments for GXVBANK_TERM_DATE (# 11)

Source Code Comments

TERMINATION DATE: The date when the record is no longer in effect.

Columns Comments for GXVBANK_COAS_CODE (# 12)

Source Code Comments

CHART OF ACCOUNTS CODE: The primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment.

Columns Comments for GXVBANK_ACCT_CODE_CASH (# 13)

Source Code Comments

CASH ACCOUNT CODE: This is the account number and title of the installments cash balances in the bank fund.

Columns Comments for GXVBANK_ACCT_CODE_INTERFUND (# 14)

Source Code Comments

INTERFUND CASH ACCOUNT CODE: This is the acount number and title of the installments cash balance in each operating ledger.

Columns Comments for GXVBANK_FUND_CODE (# 15)

Source Code Comments

FUND CODE: A code which uniquely identifies a fiscal entity.

Columns Comments for GXVBANK_CURR_CODE (# 16)

Source Code Comments

CURRENCY CODE: Currency code established for the bank.

Columns Comments for GXVBANK_ACH_DEST_NO (# 17)

Source Code Comments

DESTINATION ROUTING NO: The routing number of the clearing house bank uses.

Columns Comments for GXVBANK_ACH_ORIG_NO (# 18)

Source Code Comments

ORIGINATING ROUTING NO: The routing number of the bank.

Columns Comments for GXVBANK_ACH_DEST_NAME (# 19)

Source Code Comments

DESTINATION BANK NAME: The name of the clearing house bank uses.

Columns Comments for GXVBANK_ACH_SHORT_ORIG_NAME (# 20)

Source Code Comments

ORIGINATING BANK NAME: The short name of the bank should be less than 15 characters long.

Columns Comments for GXVBANK_COMPANY_TYPE (# 21)

Source Code Comments

ORGANIZATION NUMBER TYPE : Type code used to identify the type of Organization Identification.

Columns Comments for GXVBANK_COMPANY_ID (# 22)

Source Code Comments

ORGANIZATION IDENTIFICATION NUMBER : Code used to identify an originator(creater) of direct deposit tape.

Columns Comments for GXVBANK_ACH_ORIG_NAME (# 23)

Source Code Comments

ORIGINATING LONG NAME: The long name of the bank.

Columns Comments for GXVBANK_BANK_ROUT_NUM (# 24)

Source Code Comments

ORIGINATING BANK ROUTING NUMBER: The routing number that is associated with the originating bank.

Columns Comments for GXVBANK_ACH_FILE_NUMBER (# 25)

Source Code Comments

ACH FILE NUMBER : The number of direct deposit tape file that has been produced from this bank.

Table GXVDIRD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXVDIRD_CODE_BANK_ROUT_NUM   VARCHAR2(9) No *  
GXVDIRD_DESC   VARCHAR2(60) No    
GXVDIRD_ACTIVITY_DATE   DATE No    
GXVDIRD_USER_ID   VARCHAR2(30) No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GXVDIRD Unique GXVDIRD_CODE_BANK_ROUT_NUM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GXRDIRD SQL Table S10B80.GENERAL Refer (no action)
PEBPAYM SQL Table S10B80.PAYROLL Refer (no action)
PHRDOCM SQL Table S10B80.PAYROLL Refer (no action)
F_GET_DESC SQL Function S10B80.BANINST1 Use (select)
PAY_DOCM_TYPE Oracle Package Type S10B80.BANINST1.BWPKHSTB Rely On
P_JS_FILLARRAYS Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
P_JS_FILLARRAYS Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (select)Rely On
GET_PAY_DOCMC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
P_FORMATDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.PHKLIBS Rely On
P_MODIFYDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
P_UPDATEDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (select)
GXVDIRD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GXVDIRD SQL Index S10B80.GENERAL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GXVDIRD

Object Dates

Creation Date Analysis Date
04/02/2008 20:32:40:000 04/02/2008 21:17:56:000

Source Code Comments

Recipient Bank Validation Table

Columns Comments for GXVDIRD_CODE_BANK_ROUT_NUM (# 1)

Source Code Comments

BANK ROUTING NUMBER : Bank routing number of the bank.

Columns Comments for GXVDIRD_DESC (# 2)

Source Code Comments

DESCRIPTION : Descriptive name for the bank.

Columns Comments for GXVDIRD_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE : Date of last activity on this record.

Columns Comments for GXVDIRD_USER_ID (# 4)

Source Code Comments

USER ID : The user id of the person who updates this record.

Table PEBPAYM

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEBPAYM_PIDM   NUMBER(8,0) No *  
PEBPAYM_DOC_TYPE   VARCHAR2(1) No    
PEBPAYM_USER_ID   VARCHAR2(30) No    
PEBPAYM_ACTIVITY_DATE   DATE No    
PEBPAYM_BANK_ROUT_NUM   VARCHAR2(9) Yes   *
PEBPAYM_BANK_ACCT_NUM   VARCHAR2(17) Yes    
PEBPAYM_ACCT_TYPE   VARCHAR2(1) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
PEBPAYM_BANK_ROUT_NUM GXVDIRD_CODE_BANK_ROUT_NUM GXVDIRD

Index

Index Name Index Type Column Name
PK_PEBPAYM Unique PEBPAYM_PIDM

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PEBPAYM SQL Index S10B80.PAYROLL Rely On
GXVDIRD SQL Table S10B80.GENERAL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PEBPAYM

Object Dates

Creation Date Analysis Date
04/02/2008 13:33:34:000 04/02/2008 13:49:07:000

Source Code Comments

One-Time Payments Payment Method Information Table.

Columns Comments for PEBPAYM_PIDM (# 1)

Source Code Comments

PIDM: Personal identification code for an individual tracked in the system.

Columns Comments for PEBPAYM_DOC_TYPE (# 2)

Source Code Comments

DOCUMENT TYPE: The document type. Valid values are: (C)heck or (D)irect Deposit.

Columns Comments for PEBPAYM_USER_ID (# 3)

Source Code Comments

USER IDENTIFICATION: User ID of the User who created or last updated the record.

Columns Comments for PEBPAYM_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for PEBPAYM_BANK_ROUT_NUM (# 5)

Source Code Comments

BANK ROUTING NO: The bank routing number of the recipients bank.

Columns Comments for PEBPAYM_BANK_ACCT_NUM (# 6)

Source Code Comments

BANK ACCOUNT NO: The account number of the recipients account.

Columns Comments for PEBPAYM_ACCT_TYPE (# 7)

Source Code Comments

ACCOUNT TYPE: The type of account for direct deposit (checking or savings).

Table PHRDOCM

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PHRDOCM_YEAR   VARCHAR2(4) No *  
PHRDOCM_PICT_CODE   VARCHAR2(2) No *  
PHRDOCM_PAYNO   NUMBER(3,0) No *  
PHRDOCM_PIDM   NUMBER(8,0) No *  
PHRDOCM_SEQ_NO   NUMBER(2,0) No *  
PHRDOCM_DOC_TYPE   VARCHAR2(1) No *  
PHRDOCM_PRIORITY   NUMBER(2,0) No *  
PHRDOCM_DOC_NO   VARCHAR2(9) No *  
PHRDOCM_DOC_DATE   DATE No    
PHRDOCM_NET   NUMBER(11,2) Yes    
PHRDOCM_BANK_CODE   VARCHAR2(9) Yes   *
PHRDOCM_BANK_ACCT_NO   VARCHAR2(17) Yes    
PHRDOCM_ACCT_TYPE   VARCHAR2(1) Yes    
PHRDOCM_ACTIVITY_DATE   DATE No    
PHRDOCM_RECON_IND   VARCHAR2(1) Yes    
PHRDOCM_RECON_DATE   DATE Yes    
PHRDOCM_REISSUE_IND   VARCHAR2(1) No    

Foreign Key information

Column name is Foreign Key For Column on Table
PHRDOCM_BANK_CODE GXVDIRD_CODE_BANK_ROUT_NUM GXVDIRD

Index

Index Name Index Type Column Name
PHRDOCM_KEY2_INDEX   PHRDOCM_DOC_TYPE
PHRDOCM_KEY2_INDEX   PHRDOCM_DOC_DATE
PHRDOCM_KEY2_INDEX   PHRDOCM_YEAR
PHRDOCM_KEY2_INDEX   PHRDOCM_PICT_CODE
PHRDOCM_KEY2_INDEX   PHRDOCM_PAYNO
PHRDOCM_KEY2_INDEX   PHRDOCM_PIDM
PHRDOCM_KEY2_INDEX   PHRDOCM_SEQ_NO
PHRDOCM_KEY3_INDEX   PHRDOCM_PIDM
PHRDOCM_KEY3_INDEX   PHRDOCM_YEAR
PHRDOCM_KEY3_INDEX   PHRDOCM_PICT_CODE
PHRDOCM_KEY3_INDEX   PHRDOCM_PAYNO
PHRDOCM_KEY3_INDEX   PHRDOCM_SEQ_NO
PHRDOCM_KEY4_INDEX   PHRDOCM_DOC_NO
PHRDOCM_KEY4_INDEX   PHRDOCM_DOC_DATE
PK_PHRDOCM Unique PHRDOCM_YEAR
PK_PHRDOCM Unique PHRDOCM_PICT_CODE
PK_PHRDOCM Unique PHRDOCM_PAYNO
PK_PHRDOCM Unique PHRDOCM_PIDM
PK_PHRDOCM Unique PHRDOCM_SEQ_NO
PK_PHRDOCM Unique PHRDOCM_DOC_TYPE
PK_PHRDOCM Unique PHRDOCM_PRIORITY
PK_PHRDOCM Unique PHRDOCM_DOC_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PHRHIST SQL Table S10B80.PAYROLL Join
PAY_DOCM_TYPE Oracle Package Type S10B80.BANINST1.BWPKHSTB Rely On
PAY_SUM_TYPE Oracle Package Type S10B80.BANINST1.BWPKHSTB Rely On
DOC_DATE Oracle Package Variable S10B80.BANINST1.BWPKHSTB Rely On
GET_ADJS_DOCC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
P_GET_ORIGINAL_DATE Oracle Package Procedure S10B80.BANINST1.BWPKHSTB Use (select)
F_CHECK_IF_ADJUSTED Oracle Package Function S10B80.BANINST1.BWPKHSTB Use (select)
GET_PAY_DOCMC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
GET_PAY_SUMC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
PHRDOCMC Oracle Package Cursor S10B80.BANINST1.PHKLIBS Use (select)Rely On
P_CHOOSEPAYSTUBYEAR Oracle Package Procedure S10B80.BANINST1.BWPKHSTB Use (select)
P_DISPPAYSTUBDTL Oracle Package Procedure S10B80.BANINST1.BWPKHSTB Rely On
P_VIEWDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Rely On
P_VIEWDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (select)
F_POSTING_DATE Oracle Package Function S10B80.BANINST1.POKLIBS Use (select)
PHRDOCM Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PHRDOCM_KEY2_INDEX SQL Index S10B80.PAYROLL Rely On
PHRDOCM_KEY3_INDEX SQL Index S10B80.PAYROLL Rely On
PHRDOCM_KEY4_INDEX SQL Index S10B80.PAYROLL Rely On
PK_PHRDOCM SQL Index S10B80.PAYROLL Rely On
GXVDIRD SQL Table S10B80.GENERAL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PHRDOCM

Object Dates

Creation Date Analysis Date
04/02/2008 13:35:26:000 04/02/2008 13:49:09:000

Source Code Comments

Document Number Repeating Table

Columns Comments for PHRDOCM_YEAR (# 1)

Source Code Comments

YEAR: The year of the payroll that generated the documents.

Columns Comments for PHRDOCM_PICT_CODE (# 2)

Source Code Comments

PAYROLL IDENTIFICATION CODE: The pay id that generated the document.

Columns Comments for PHRDOCM_PAYNO (# 3)

Source Code Comments

PAYROLL NUMBER: The number of the payroll that generated the document.

Columns Comments for PHRDOCM_PIDM (# 4)

Source Code Comments

PIDM: Internal ID number.

Columns Comments for PHRDOCM_SEQ_NO (# 5)

Source Code Comments

SEQUENCE NUMBER: The sequence number of this pay event.

Columns Comments for PHRDOCM_DOC_TYPE (# 6)

Source Code Comments

DOCUMENT TYPE; Indicates whether the document is a check or a direct deposit notification.

Columns Comments for PHRDOCM_PRIORITY (# 7)

Source Code Comments

PRIORITY: The sequence that the documents are generated in.

Columns Comments for PHRDOCM_DOC_NO (# 8)

Source Code Comments

DOCUMENT NUMBER: The check or direct deposit notice number.

Columns Comments for PHRDOCM_DOC_DATE (# 9)

Source Code Comments

DOCUMENT DATE: Date of the check or direct deposit notification.

Columns Comments for PHRDOCM_NET (# 10)

Source Code Comments

NET AMOUNT: The amount of the check or direct deposit.

Columns Comments for PHRDOCM_BANK_CODE (# 11)

Source Code Comments

BANK CODE; Specifies the bank where the money is to be deposited. This must be established on the GXADIRD form.

Columns Comments for PHRDOCM_BANK_ACCT_NO (# 12)

Source Code Comments

BANK ACCOUNT NUMBER: The bank account number for the direct deposit.

Columns Comments for PHRDOCM_ACCT_TYPE (# 13)

Source Code Comments

DIRECT DEPOSIT ACCOUNT TYPE: The type of account for direct deposit (savings or checking).

Columns Comments for PHRDOCM_ACTIVITY_DATE (# 14)

Source Code Comments

ACTIVITY DATE: Date of last activity (insert or update) on this record.

Columns Comments for PHRDOCM_RECON_IND (# 15)

Source Code Comments

RECON IND: Bank reconciliation indicator. When a check is reconciled this field will be valued with an (R)

Columns Comments for PHRDOCM_RECON_DATE (# 16)

Source Code Comments

RECON DATE: Reconciliation date. The date from the bank statement on which the check was reconciled.

Columns Comments for PHRDOCM_REISSUE_IND (# 17)

Source Code Comments

Reissue Indicator: Indicates if this document should be reissued.

Table PHRHIST

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PHRHIST_YEAR   VARCHAR2(4) No * *
PHRHIST_PICT_CODE   VARCHAR2(2) No * *
PHRHIST_PAYNO   NUMBER(3,0) No * *
PHRHIST_PIDM   NUMBER(8,0) No * *
PHRHIST_SEQ_NO   NUMBER(2,0) No * *
PHRHIST_DISP   VARCHAR2(2) No    
PHRHIST_EVENT_DATE   DATE Yes    
PHRHIST_GROSS   NUMBER(11,2) Yes    
PHRHIST_NET   NUMBER(11,2) Yes    
PHRHIST_TYPE_IND   VARCHAR2(1) No    
PHRHIST_CALC_IND   VARCHAR2(1) No    
PHRHIST_PRINT_IND   VARCHAR2(1) No    
PHRHIST_ADJS_SEQ_NO   NUMBER(2,0) Yes    
PHRHIST_ADJS_DATE   DATE Yes    
PHRHIST_ADJ_BY_SEQ_NO   VARCHAR2(2) Yes    
PHRHIST_ADJ_BY_DATE   DATE Yes    
PHRHIST_ASSOC_SEQ_NO   NUMBER(2,0) Yes    
PHRHIST_ACTIVITY_DATE   DATE No    
PHRHIST_UI_WEEKS   NUMBER(5,3) Yes    
PHRHIST_UI_EXCEPTION_IND   VARCHAR2(1) Yes    
PHRHIST_UPDT_DATE   DATE Yes    
PHRHIST_POSTING_OVERRIDE_DATE   DATE Yes    
PHRHIST_USER_ID   VARCHAR2(30) Yes    
PHRHIST_COMMENT   VARCHAR2(2000) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
PHRHIST_YEAR PTRCALN_YEAR PTRCALN
PHRHIST_PICT_CODE PTRCALN_PICT_CODE PTRCALN
PHRHIST_PAYNO PTRCALN_PAYNO PTRCALN
PHRHIST_PIDM PEBEMPL_PIDM PEBEMPL
PHRHIST_YEAR PHRJOBS_YEAR PHRJOBS
PHRHIST_PICT_CODE PHRJOBS_PICT_CODE PHRJOBS
PHRHIST_PAYNO PHRJOBS_PAYNO PHRJOBS
PHRHIST_SEQ_NO PHRJOBS_SEQ_NO PHRJOBS
PHRHIST_PIDM PHRJOBS_PIDM PHRJOBS
PHRHIST_SEQ_NO PHRDOCM_SEQ_NO PHRDOCM
PHRHIST_PAYNO PHRDOCM_PAYNO PHRDOCM
PHRHIST_PICT_CODE PHRDOCM_PICT_CODE PHRDOCM
PHRHIST_YEAR PHRDOCM_YEAR PHRDOCM
PHRHIST_PIDM PHRDOCM_PIDM PHRDOCM

Index

Index Name Index Type Column Name
PHRHIST_KEY2_INDEX   PHRHIST_PIDM
PHRHIST_KEY2_INDEX   PHRHIST_YEAR
PHRHIST_KEY2_INDEX   PHRHIST_PICT_CODE
PHRHIST_KEY2_INDEX   PHRHIST_PAYNO
PHRHIST_KEY2_INDEX   PHRHIST_SEQ_NO
PHRHIST_KEY3_INDEX   PHRHIST_DISP
PHRHIST_KEY3_INDEX   PHRHIST_YEAR
PHRHIST_KEY3_INDEX   PHRHIST_PICT_CODE
PHRHIST_KEY3_INDEX   PHRHIST_PAYNO
PHRHIST_KEY3_INDEX   PHRHIST_PRINT_IND
PHRHIST_KEY4_INDEX   PHRHIST_YEAR
PHRHIST_KEY4_INDEX   PHRHIST_PICT_CODE
PHRHIST_KEY4_INDEX   PHRHIST_PAYNO
PHRHIST_KEY4_INDEX   PHRHIST_SEQ_NO
PHRHIST_KEY4_INDEX   PHRHIST_DISP
PHRHIST_KEY5_INDEX   PHRHIST_UPDT_DATE
PK_PHRHIST Unique PHRHIST_YEAR
PK_PHRHIST Unique PHRHIST_PICT_CODE
PK_PHRHIST Unique PHRHIST_PAYNO
PK_PHRHIST Unique PHRHIST_PIDM
PK_PHRHIST Unique PHRHIST_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERJLEV SQL Table S10B80.PAYROLL Join
PHR1042 SQL Table S10B80.PAYROLL Join
PHRCMNT SQL Table S10B80.PAYROLL Refer (no action)
PHREARN SQL Table S10B80.PAYROLL Join
PHRJACR SQL Table S10B80.PAYROLL Join
PTRPICT SQL Table S10B80.PAYROLL Join
PHVUPDT SQL View S10B80.BANINST1 Use (select)
PAY_SUM_TYPE Oracle Package Type S10B80.BANINST1.BWPKHSTB Rely On
PAYNO Oracle Package Variable S10B80.BANINST1.BWPKHSTB Rely On
PICT Oracle Package Variable S10B80.BANINST1.BWPKHSTB Rely On
SEQ_NO Oracle Package Variable S10B80.BANINST1.BWPKHSTB Rely On
YR Oracle Package Variable S10B80.BANINST1.BWPKHSTB Rely On
GET_ADJS_DOCC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
GET_GROSS_NETC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
PRINT_THIS_EVENT Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
P_COMPUTE_BOX_AMOUNTS Oracle Package Procedure S10B80.BANINST1.PP_W2_2006 Use (select)
P_COMPUTE_BOX_AMOUNTS Oracle Package Procedure S10B80.BANINST1.PP_W2_2007 Use (select)
P_COMPUTE_BOX_AMOUNTS Oracle Package Procedure S10B80.BANINST1.PP_W2 Use (select)
P_GET_ORIGINAL_DATE Oracle Package Procedure S10B80.BANINST1.BWPKHSTB Use (select)
UT_NB_JOB_EARNINGSDELETEAPI Oracle Package Procedure S10B80.BANINST1.UT_NB_JOB_EARNINGS Use (Insert)
UT_NB_JOB_EARNINGSUPDATEAPI Oracle Package Procedure S10B80.BANINST1.UT_NB_JOB_EARNINGS Use (Insert)
F_CHECK_IF_ADJUSTED Oracle Package Function S10B80.BANINST1.BWPKHSTB Use (select)
GET_PAY_SUMC Oracle Package Cursor S10B80.BANINST1.BWPKHSTB Use (select)
PHRHISTC Oracle Package Cursor S10B80.BANINST1.PHKLIBS Use (select)Rely On
P_ACCRUE_SENIORITY_HOURS Oracle Package Procedure S10B80.BANINST1.PEKSNBL Use (select)
P_CHOOSEPAYSTUBYEAR Oracle Package Procedure S10B80.BANINST1.BWPKHSTB Use (select)
P_DISPPAYSTUBDTL Oracle Package Procedure S10B80.BANINST1.BWPKHSTB Rely On
P_MAIN_ROLL Oracle Package Procedure S10B80.BANINST1.PEKLEAV Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.PB_PAYHIST_COMMENT_RULES Use (select)
P_VIEWDIRECTDEPOSIT Oracle Package Procedure S10B80.BANINST1.BWPKHPAY Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_PAYHIST_COMMENT Use (Insert)
F_GET_JOB_LEAVE_ACCRUAL Oracle Package Function S10B80.BANINST1.PEKLEAV Use (select)
F_GET_LAST_PAID_DATE Oracle Package Function S10B80.BANINST1.NOKPLIB Use (select)
F_GET_POSN_LAST_PAID_DATE Oracle Package Function S10B80.BANINST1.NOKP3LB Use (select)
F_LASTPAIDDATE Oracle Package Function S10B80.BANINST1.POKLIBS Use (select)
F_VALID_EMPR_CODE Oracle Package Function S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT Use (select)
F_VALID_EMPR_CODE Oracle Package Function S10B80.BANINST1.PX_MASS_ROE Use (select)
PHRHIST Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PHRHIST_KEY2_INDEX SQL Index S10B80.PAYROLL Rely On
PHRHIST_KEY3_INDEX SQL Index S10B80.PAYROLL Rely On
PHRHIST_KEY4_INDEX SQL Index S10B80.PAYROLL Rely On
PHRHIST_KEY5_INDEX SQL Index S10B80.PAYROLL Rely On
PK_PHRHIST SQL Index S10B80.PAYROLL Rely On
PEBEMPL SQL Table S10B80.PAYROLL Refer (no action)
PHRDOCM SQL Table S10B80.PAYROLL Join
PHRJOBS SQL Table S10B80.PAYROLL Join
PTRCALN SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PHRHIST

Object Dates

Creation Date Analysis Date
04/02/2008 13:33:58:000 04/02/2008 13:49:08:000

Source Code Comments

Pay History Repeating Table

Columns Comments for PHRHIST_YEAR (# 1)

Source Code Comments

Year; The year of the payroll.

Columns Comments for PHRHIST_PICT_CODE (# 2)

Source Code Comments

PAYROLL IDENTIFICATION CODE: The pay id of the event.

Columns Comments for PHRHIST_PAYNO (# 3)

Source Code Comments

PAYROLL NUMBER: The pay number of the year for this payroll.

Columns Comments for PHRHIST_PIDM (# 4)

Source Code Comments

PIDM: Internal ID number.

Columns Comments for PHRHIST_SEQ_NO (# 5)

Source Code Comments

SEQUENCE NUMBER: The sequence number of the event.

Columns Comments for PHRHIST_DISP (# 6)

Source Code Comments

DISPOSITION: Indicates the status of this pay event through the pay cycle.

Columns Comments for PHRHIST_EVENT_DATE (# 7)

Source Code Comments

PAY EVENT DATE: The date on the checks or notices of direct deposit. Or the date of the event when no document is associated.

Columns Comments for PHRHIST_GROSS (# 8)

Source Code Comments

GROSS AMOUNT: The total gross for the event.

Columns Comments for PHRHIST_NET (# 9)

Source Code Comments

NET AMOUNT: The total net amount of the event.

Columns Comments for PHRHIST_TYPE_IND (# 10)

Source Code Comments

TYPE INDICATOR: Indicates the type of pay event.

Columns Comments for PHRHIST_CALC_IND (# 11)

Source Code Comments

CALCULATION INDICATOR: Indicates how this event was calculated (manually or via the calc program).

Columns Comments for PHRHIST_PRINT_IND (# 12)

Source Code Comments

PRINT INDICATOR: Indicates if the event was manually printed outside of the system.

Columns Comments for PHRHIST_ADJS_SEQ_NO (# 13)

Source Code Comments

ADJUSTS SEQUENCE NUMBER: The sequence number of the pay event that this one adjusts.

Columns Comments for PHRHIST_ADJS_DATE (# 14)

Source Code Comments

ADJUSTS DATE: The date of the pay event that this event adjusts.

Columns Comments for PHRHIST_ADJ_BY_SEQ_NO (# 15)

Source Code Comments

ADJUSTED BY SEQUENCE NUMBER: The sequence number of the pay event that adjuststhis pay event.

Columns Comments for PHRHIST_ADJ_BY_DATE (# 16)

Source Code Comments

ADJUSTED BY DATE: The date of the pay event that adjusts this pay event.

Columns Comments for PHRHIST_ASSOC_SEQ_NO (# 17)

Source Code Comments

ASSOCIATED SEQUENCE NUMBER: The sequence of the event that corresponds to thisevent for two step adjustments.

Columns Comments for PHRHIST_ACTIVITY_DATE (# 18)

Source Code Comments

ACTIVITY DATE: Date of last activity (update or insert) on this record.

Columns Comments for PHRHIST_UI_WEEKS (# 19)

Source Code Comments

UI WEEKS: Unemployment Insurance insurable for this pay period.

Columns Comments for PHRHIST_UI_EXCEPTION_IND (# 20)

Source Code Comments

UNEMPLOYMENT EXCEPTION INDICATOR: (H)ourly, (M)aximum, numbers, null can be accepted. This field is associated with insurable earnings by pay period.

Columns Comments for PHRHIST_UPDT_DATE (# 21)

Source Code Comments

UPDATE DATE: The date that the phpupdt payroll process was run for supplemental pay or adjustments. Used in Tax Reporting.

Columns Comments for PHRHIST_POSTING_OVERRIDE_DATE (# 22)

Source Code Comments

POSTING OVERRIDE DATE: Finance Posting Override Date.

Columns Comments for PHRHIST_USER_ID (# 23)

Source Code Comments

USER ID: User Identification Number.

Columns Comments for PHRHIST_COMMENT (# 24)

Source Code Comments

COMMENT: This field stores user comments

Table STVNATN

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
STVNATN_CODE   VARCHAR2(5) No *  
STVNATN_NATION   VARCHAR2(30) No    
STVNATN_CAPITAL   VARCHAR2(20) Yes    
STVNATN_AREA   NUMBER(22,0) Yes    
STVNATN_POPULATION   NUMBER(22,0) Yes    
STVNATN_ACTIVITY_DATE   DATE No    
STVNATN_EDI_EQUIV   VARCHAR2(2) Yes    
STVNATN_LMS_EQUIV   VARCHAR2(2) Yes    
STVNATN_POSTAL_MASK   VARCHAR2(15) Yes    
STVNATN_TELE_MASK   VARCHAR2(15) Yes    
STVNATN_STATSCAN_CDE   VARCHAR2(5) Yes    
STVNATN_SCOD_CODE_ISO   VARCHAR2(3) Yes    
STVNATN_SSA_REPORTING_EQUIV   VARCHAR2(2) Yes    
STVNATN_SEVIS_EQUIV   VARCHAR2(2) Yes    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_STVNATN Unique STVNATN_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
STVNATN Oracle Synonym S10B80.FAISMGR Rely On
AORCONT SQL Table S10B80.ALUMNI Refer (no action)
APBCONS SQL Table S10B80.ALUMNI Refer (no action)
APBWIDN SQL Table S10B80.ALUMNI Refer (no action)
GOBINTL SQL Table S10B80.GENERAL Refer (no action)
GOBSEVS SQL Table S10B80.GENERAL Refer (no action)
GORSEVD SQL Table S10B80.GENERAL Refer (no action)
GORVISA SQL Table S10B80.GENERAL Refer (no action)
GTVCURR SQL Table S10B80.GENERAL Refer (no action)
GTVZIPC SQL Table S10B80.GENERAL Refer (no action)
GUBINST SQL Table S10B80.GENERAL Refer (no action)
GURAPAY SQL Table S10B80.GENERAL Refer (no action)
PPREXPE SQL Table S10B80.PAYROLL Refer (no action)
PTRHSIL SQL Table S10B80.PAYROLL Refer (no action)
PTRJBLN SQL Table S10B80.PAYROLL Refer (no action)
PXRMTER SQL Table S10B80.PAYROLL Refer (no action)
PXRMTIN SQL Table S10B80.PAYROLL Refer (no action)
RJBPLBD SQL Table S10B80.FAISMGR Refer (no action)
RPBLNDR SQL Table S10B80.FAISMGR Refer (no action)
RPRLAPP SQL Table S10B80.FAISMGR Refer (no action)
RPRLARF SQL Table S10B80.FAISMGR Refer (no action)
SABSUPL SQL Table S10B80.SATURN Refer (no action)
SFRENRL SQL Table S10B80.SATURN Refer (no action)
SHBDIPL SQL Table S10B80.SATURN Refer (no action)
SHBGAPP SQL Table S10B80.SATURN Refer (no action)
SHTTRAN SQL Table S10B80.SATURN Refer (no action)
SHTTRTC SQL Table S10B80.SATURN Refer (no action)
SMRPRRQ SQL Table S10B80.SATURN Refer (no action)
SMTPRRQ SQL Table S10B80.SATURN Refer (no action)
SOBSBGI SQL Table S10B80.SATURN Refer (no action)
SPBPERS SQL Table S10B80.SATURN Refer (no action)
SPRADDR SQL Table S10B80.SATURN Refer (no action)
SPREMRG SQL Table S10B80.SATURN Refer (no action)
SPRINTL SQL Table S10B80.SATURN Refer (no action)
SRTADDR SQL Table S10B80.SATURN Refer (no action)
SRTHSCH SQL Table S10B80.SATURN Refer (no action)
SRTINTL SQL Table S10B80.SATURN Refer (no action)
SRTPCOL SQL Table S10B80.SATURN Refer (no action)
SRTSUPL SQL Table S10B80.SATURN Refer (no action)
STVEMPL SQL Table S10B80.SATURN Refer (no action)
AF_VENDOR_VOLUME SQL View S10B80.BANINST1 Use (select)
APVADRS SQL View S10B80.BANINST1 Use (select)
GOVSVDP SQL View S10B80.BANINST1 Use (select)
GOVSVEV SQL View S10B80.BANINST1 Use (select)
GOVSVSD SQL View S10B80.BANINST1 Use (select)
PAVAPPL SQL View S10B80.BANINST1 Use (select)
PEVEMPL SQL View S10B80.BANINST1 Use (select)
POVDATA SQL View S10B80.BANINST1 Use (select)
PPVADRS SQL View S10B80.BANINST1 Use (select)
RPVADDR SQL View S10B80.BANINST1 Use (select)
RPVADRS SQL View S10B80.BANINST1 Use (select)
RPVFDRS SQL View S10B80.BANINST1 Use (select)
SAVADRS SQL View S10B80.BANINST1 Use (select)
SGVADRS SQL View S10B80.BANINST1 Use (select)
SPVADDF SQL View S10B80.BANINST1 Use (select)
SPVADDI SQL View S10B80.BANINST1 Use (select)
SPVADDS SQL View S10B80.BANINST1 Use (select)
SPVADRS SQL View S10B80.BANINST1 Use (select)
SPVINTL SQL View S10B80.BANINST1 Use (select)
SRVADRS SQL View S10B80.BANINST1 Use (select)
STVNATV SQL View S10B80.BANINST1 Use (select)
F_COMMON_GET_DESC SQL Function S10B80.BANINST1 Use (select)
F_GET_DESC SQL Function S10B80.BANINST1 Use (select)
F_GET_DESC_ALUMNI SQL Function S10B80.BANINST1 Use (select)
F_GET_DESC_FNC SQL Function S10B80.BANINST1 Use (select)
F_STUDENT_GET_DESC SQL Function S10B80.BANINST1 Use (select)
ADDRESS_REC_TYPE Oracle Package Type S10B80.BANINST1.ICSPKCOM Rely On
NATN_CUR Oracle Package Cursor S10B80.BANINST1.BWSKALOG Use (select)
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWDKSRCH Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWDKCPRF Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWAKADVS Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWGKOADR Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWAKJPST Rely On
GETSTVNATNC Oracle Package Cursor S10B80.BANINST1.BWAKALOG Use (select)Rely On
STVNATNC Oracle Package Cursor S10B80.BANINST1.BWSKWTRR Use (select)
STVNATNVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKSRCH Use (select)Rely On
STVNATNVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKCPRF Use (select)Rely On
STVNATNVIEWC Oracle Package Cursor S10B80.BANINST1.BWAKJPST Use (select)Rely On
STVNATN_LISTC Oracle Package Cursor S10B80.BANINST1.BWSKRQST Use (select)
P_GENOPTIONSNATN Oracle Package Procedure S10B80.BANINST1.BWGKOADR Rely On
P_LOOKUPSBGICODE Oracle Package Procedure S10B80.BANINST1.BWSKWPRO Use (select)
CUR_OF_NATN Oracle Package Variable S10B80.BANINST1.BWPKEDIR Rely On
CUR_PR_NATN Oracle Package Variable S10B80.BANINST1.BWPKEDIR Rely On
GV_NATION_CODE1 Oracle Package Variable S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT Rely On
GV_NATION_CODE2 Oracle Package Variable S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT Rely On
GV_NATION_CODE3 Oracle Package Variable S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT Rely On
GV_NATION_CODE4 Oracle Package Variable S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT Rely On
GV_NATN_DESC Oracle Package Variable S10B80.BANINST1.BWSKRQST Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWGKOEMR Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWAKALOG Rely On
STVNATN_REC Oracle Package Variable S10B80.BANINST1.BWGKOPRF Rely On
F_GET_NATN_DESC Oracle Package Function S10B80.BANINST1.BWSKWTRR Rely On
F_GET_NATN_DESC Oracle Package Function S10B80.BANINST1.BWSKWTRR Use (select)
STVNATNC Oracle Package Cursor S10B80.BANINST1.STKNATN Use (select)Rely On
STVNATNLISTC Oracle Package Cursor S10B80.BANINST1.BWSKLIST Use (select)Rely On
STVNATNLISTC Oracle Package Cursor S10B80.BANINST1.GOKLIBS Use (select)Rely On
STVNATN_C Oracle Package Cursor S10B80.BANINST1.GB_STVNATN Rely On
STVNATN_C Oracle Package Cursor S10B80.BANINST1.GB_STVNATN Use (select)Rely On
P_CCPAYMENTSTATUS Oracle Package Procedure S10B80.BANINST1.BWAKCPMT Rely On
P_CCPAYMENTSTATUS Oracle Package Procedure S10B80.BANINST1.BWAKNGFT Rely On
P_CCPAYMENTSTATUS Oracle Package Procedure S10B80.BANINST1.BWSKAPMT Rely On
P_CCPAYMENTSTATUS Oracle Package Procedure S10B80.BANINST1.BWCKCPMT Rely On
P_CC_PAYMENT_STATUS Oracle Package Procedure S10B80.BANINST1.BWSKWCCP Rely On
P_COLLECT_CREDIT_CARD_INFO Oracle Package Procedure S10B80.BANINST1.BWGKCCRD Rely On
P_CREDITCARDPAYMENT Oracle Package Procedure S10B80.BANINST1.BWAKCPMT Rely On
P_CREDITCARDPAYMENT Oracle Package Procedure S10B80.BANINST1.BWSKAPMT Rely On
P_CREDITCARDPAYMENT Oracle Package Procedure S10B80.BANINST1.BWCKCPMT Rely On
P_CREDIT_CARD_PAYMENT Oracle Package Procedure S10B80.BANINST1.BWSKWCCP Rely On
P_DELETE_STVNATN Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Rely On
P_DELETE_STVNATN Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Use (delete)
P_DISPADDRVIEW Oracle Package Procedure S10B80.BANINST1.BWLKOSAD Rely On
P_DISPADDRVIEW Oracle Package Procedure S10B80.BANINST1.BWGKOADR Rely On
P_DISPSTATUS Oracle Package Procedure S10B80.BANINST1.BWSKASTA Rely On
P_DISPSTATUSSARADAP Oracle Package Procedure S10B80.BANINST1.BWSKASTA Rely On
P_DISP_CONFIRM Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_DIPLOMA_ADDR Oracle Package Procedure S10B80.BANINST1.BWSKGRAD Use (select)
P_DISP_STATUS_OF_ORDER Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_TRANSCRIPT_REQUEST_TYPE Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_EDIT_SHIP_CODE Oracle Package Procedure S10B80.BANINST1.FSKSHIP Rely On
P_EDIT_SHIP_CODE Oracle Package Procedure S10B80.BANINST1.FSKSHIP Use (select)
P_GET_SOBSBGI_INFO Oracle Package Procedure S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP Use (select)
P_INSERT_INTL Oracle Package Procedure S10B80.BANINST1.SRKPREL Rely On
P_INSERT_INTL Oracle Package Procedure S10B80.BANINST1.SRKPREL Use (select)
P_INSERT_STVNATN Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Rely On
P_INSERT_STVNATN Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Use (Insert)
P_LOAD_INTL Oracle Package Procedure S10B80.BANINST1.SAKL030 Rely On
P_LOAD_INTL Oracle Package Procedure S10B80.BANINST1.SAKL030 Use (select)
P_LOOKUP_SBGI_CODE Oracle Package Procedure S10B80.BANINST1.BWSKALOG Use (select)
P_MAKE_A_DONATION Oracle Package Procedure S10B80.BANINST1.BWAKNGFT Rely On
P_PROCADDRUPDATE Oracle Package Procedure S10B80.BANINST1.BWGKOGAD Rely On
P_PURCHASEORDER Oracle Package Procedure S10B80.BANINST1.BWFKPURR Rely On
P_PURCHASEORDER Oracle Package Procedure S10B80.BANINST1.BWFKPURR Use (select)
P_REQUISITION Oracle Package Procedure S10B80.BANINST1.BWFKREQN Rely On
P_REQUISITION Oracle Package Procedure S10B80.BANINST1.BWFKREQN Use (select)
P_UPDATE_STVNATN Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Rely On
P_UPDATE_STVNATN Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Use (update)
P_VALADDRUPDATE Oracle Package Procedure S10B80.BANINST1.BWGKOADR Rely On
P_VALIDATION_DISPLAY Oracle Package Procedure S10B80.BANINST1.BWGKCCRD Rely On
P_VIEWDCSR Oracle Package Procedure S10B80.BANINST1.BWFKVDCR Rely On
P_VIEWINV Oracle Package Procedure S10B80.BANINST1.BWFKVINV Rely On
P_VIEWPUR Oracle Package Procedure S10B80.BANINST1.BWFKVPUR Rely On
P_VIEWREQ Oracle Package Procedure S10B80.BANINST1.BWFKVREQ Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_EXPERIENCE Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_VISA Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_DRIVER_LICENSE Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SP_HOUSING_PROFILE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_BIO Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_CERTIFICATION Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GP_CARDHOLDER Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_GRADAPP Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_EFDTEST Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GP_ENTITY_ADDRESS Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_TB_MISC_HEADER Use (Insert)
F_CALC_NATION Oracle Package Function S10B80.BANINST1.ICSPKCOM Rely On
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.GB_STVNATN Rely On
F_DOMESTIC_ADDR Oracle Package Function S10B80.BANINST1.SHKPXML Rely On
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.GB_STVNATN Rely On
F_GET_NATN_DESC Oracle Package Function S10B80.BANINST1.BWFKVDOC Rely On
F_GET_NATN_DESC Oracle Package Function S10B80.BANINST1.BWFKVDOC Use (select)
F_GET_NATN_DESC Oracle Package Function S10B80.BANINST1.TTKSELS Rely On
F_GET_NATN_DESC Oracle Package Function S10B80.BANINST1.TTKSELS Use (select)
F_GET_STVNATN_DESC Oracle Package Function S10B80.BANINST1.FRKIDEN Rely On
F_GET_STVNATN_DESC Oracle Package Function S10B80.BANINST1.FRKIDEN Use (select)
F_OPEN_STVNATN_RC Oracle Package Function S10B80.BANINST1.NOKEPCR Use (select)
F_SORXREF_CHK Oracle Package Function S10B80.BANINST1.SAKPCOM Use (select)
F_SORXREF_VAL Oracle Package Function S10B80.BANINST1.SAKPCOM Use (select)
STVNATN Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_STVNATN SQL Index S10B80.SATURN Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVNATN

Object Dates

Creation Date Analysis Date
04/02/2008 10:35:08:000 04/02/2008 21:17:58:000

Source Code Comments

Nation Validation Table

Columns Comments for STVNATN_CODE (# 1)

Source Code Comments

This field identifies the nation code referenced in the Gen. Person, Admissions, Gen. Student, and Student Billing Modules.

Columns Comments for STVNATN_NATION (# 2)

Source Code Comments

This field specifies the nation/country associated with the nation code.

Columns Comments for STVNATN_CAPITAL (# 3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_AREA (# 4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_POPULATION (# 5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_ACTIVITY_DATE (# 6)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVNATN_EDI_EQUIV (# 7)

Source Code Comments

EDI/SPEEDE country code that equates to the nation code. Refer to the SPEEDE Implementation Guide, Appendix B, data element 26 for valid values.

Columns Comments for STVNATN_LMS_EQUIV (# 8)

Source Code Comments

LMS (IA Plus) nation (country) code that equates to this Banner nation code. Translation to this LMS code occurs during the LMS transaction feed from Banner FA.

Columns Comments for STVNATN_STATSCAN_CDE (# 11)

Source Code Comments

Statistics Canadian specific code.

Columns Comments for STVNATN_SCOD_CODE_ISO (# 12)

Source Code Comments

ISO CODE: The three character International Standards Organization (ISO) Code associated with the user defined nation code.

Columns Comments for STVNATN_SSA_REPORTING_EQUIV (# 13)

Source Code Comments

Social Security Administration country code that equates to the nation code. Refer to the Magnetic Media Reporting and Electronic Filing (MMREF-1) Guide, Appendix C, for valid values.

Columns Comments for STVNATN_SEVIS_EQUIV (# 14)

Source Code Comments

SEVIS EQUIVALENCY: SEVIS code for nation

View AF_ACCTG_DISTRIBUTION_ANALYSIS

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name Column Type Allow NULL PK FK
PIDM_KEY NUMBER(8,0) Yes    
INVOICE_CODE_KEY VARCHAR2(8) No    
MULTIPLE_INVOICE_IND VARCHAR2(1) Yes    
SUBMISSION_NUMBER_KEY NUMBER(3,0) Yes    
INVOICE_ITEM_KEY NUMBER(4,0) Yes    
SEQ_NUMBER_KEY NUMBER(4,0) Yes    
VENDOR_ID VARCHAR2(9) Yes    
VENDOR_NAME VARCHAR2(60) Yes    
ENTITY_IND VARCHAR2(1) Yes    
PURCHASE_ORDER_NUMBER VARCHAR2(8) Yes    
VENDOR_INV_NUMBER VARCHAR2(15) Yes    
INVOICE_DATE DATE Yes    
PAYMENT_DUE_DATE DATE Yes    
CANCEL_DATE DATE Yes    
TRANSACTION_DATE DATE Yes    
FSYR_CODE VARCHAR2(4) Yes    
FSPD_CODE VARCHAR2(2) Yes    
THIRD_PARTY_VENDOR_ID VARCHAR2(9) Yes    
THIRD_PARTY_VENDOR_NAME VARCHAR2(60) Yes    
THIRD_PARTY_PIDM NUMBER(8,0) Yes    
OPEN_PAID_IND VARCHAR2(1) No    
APPROVAL_IND VARCHAR2(1) Yes    
CREDIT_MEMO_IND VARCHAR2(1) No    
INVOICE_1099_IND VARCHAR2(1) Yes    
INVOICE_1099_ID VARCHAR2(9) Yes    
HOLD_IND VARCHAR2(1) No    
INVOICE_TYPE_IND VARCHAR2(1) No    
COAS_CODE VARCHAR2(1) Yes    
COAS_DESC VARCHAR2(35) Yes    
COAS_STATUS VARCHAR2(1) Yes    
FUND_CODE VARCHAR2(6) Yes    
FUND_DESC VARCHAR2(35) Yes    
ORGN_CODE VARCHAR2(6) Yes    
ORGN_DESC VARCHAR2(35) Yes    
ACCT_CODE VARCHAR2(6) Yes    
ACCT_DESC VARCHAR2(35) Yes    
PROG_CODE VARCHAR2(6) Yes    
PROG_DESC VARCHAR2(35) Yes    
LOCN_CODE VARCHAR2(6) Yes    
LOCN_DESC VARCHAR2(35) Yes    
FUND_CODE_1 VARCHAR2(6) Yes    
FUND_DESC_1 VARCHAR2(35) Yes    
FUND_STATUS_1 VARCHAR2(1) Yes    
FUND_CODE_2 VARCHAR2(6) Yes    
FUND_DESC_2 VARCHAR2(35) Yes    
FUND_STATUS_2 VARCHAR2(1) Yes    
FUND_CODE_3 VARCHAR2(6) Yes    
FUND_DESC_3 VARCHAR2(35) Yes    
FUND_STATUS_3 VARCHAR2(1) Yes    
FUND_CODE_4 VARCHAR2(6) Yes    
FUND_DESC_4 VARCHAR2(35) Yes    
FUND_STATUS_4 VARCHAR2(1) Yes    
FUND_CODE_5 VARCHAR2(6) Yes    
FUND_DESC_5 VARCHAR2(35) Yes    
FUND_STATUS_5 VARCHAR2(1) Yes    
FTYP_CODE_1 VARCHAR2(6) Yes    
FTYP_DESC_1 VARCHAR2(35) Yes    
FTYP_STATUS_1 VARCHAR2(1) Yes    
FTYP_CODE_2 VARCHAR2(6) Yes    
FTYP_DESC_2 VARCHAR2(35) Yes    
FTYP_STATUS_2 VARCHAR2(1) Yes    
ACCT_CODE_1 VARCHAR2(6) Yes    
ACCT_DESC_1 VARCHAR2(35) Yes    
ACCT_STATUS_1 VARCHAR2(1) Yes    
ACCT_CODE_2 VARCHAR2(6) Yes    
ACCT_DESC_2 VARCHAR2(35) Yes    
ACCT_STATUS_2 VARCHAR2(1) Yes    
ACCT_CODE_3 VARCHAR2(6) Yes    
ACCT_DESC_3 VARCHAR2(35) Yes    
ACCT_STATUS_3 VARCHAR2(1) Yes    
ACCT_CODE_4 VARCHAR2(6) Yes    
ACCT_DESC_4 VARCHAR2(35) Yes    
ACCT_STATUS_4 VARCHAR2(1) Yes    
ATYP_CODE_1 VARCHAR2(6) Yes    
ATYP_DESC_1 VARCHAR2(35) Yes    
ATYP_STATUS_1 VARCHAR2(1) Yes    
ATYP_CODE_2 VARCHAR2(6) Yes    
ATYP_DESC_2 VARCHAR2(35) Yes    
ATYP_STATUS_2 VARCHAR2(1) Yes    
ORGN_CODE_1 VARCHAR2(6) Yes    
ORGN_DESC_1 VARCHAR2(35) Yes    
ORGN_STATUS_1 VARCHAR2(1) Yes    
ORGN_CODE_2 VARCHAR2(6) Yes    
ORGN_DESC_2 VARCHAR2(35) Yes    
ORGN_STATUS_2 VARCHAR2(1) Yes    
ORGN_CODE_3 VARCHAR2(6) Yes    
ORGN_DESC_3 VARCHAR2(35) Yes    
ORGN_STATUS_3 VARCHAR2(1) Yes    
ORGN_CODE_4 VARCHAR2(6) Yes    
ORGN_DESC_4 VARCHAR2(35) Yes    
ORGN_STATUS_4 VARCHAR2(1) Yes    
ORGN_CODE_5 VARCHAR2(6) Yes    
ORGN_DESC_5 VARCHAR2(35) Yes    
ORGN_STATUS_5 VARCHAR2(1) Yes    
ORGN_CODE_6 VARCHAR2(6) Yes    
ORGN_DESC_6 VARCHAR2(35) Yes    
ORGN_STATUS_6 VARCHAR2(1) Yes    
ORGN_CODE_7 VARCHAR2(6) Yes    
ORGN_DESC_7 VARCHAR2(35) Yes    
ORGN_STATUS_7 VARCHAR2(1) Yes    
ORGN_CODE_8 VARCHAR2(6) Yes    
ORGN_DESC_8 VARCHAR2(35) Yes    
ORGN_STATUS_8 VARCHAR2(1) Yes    
PROG_CODE_1 VARCHAR2(6) Yes    
PROG_DESC_1 VARCHAR2(35) Yes    
PROG_STATUS_1 VARCHAR2(1) Yes    
PROG_CODE_2 VARCHAR2(6) Yes    
PROG_DESC_2 VARCHAR2(35) Yes    
PROG_STATUS_2 VARCHAR2(1) Yes    
PROG_CODE_3 VARCHAR2(6) Yes    
PROG_DESC_3 VARCHAR2(35) Yes    
PROG_STATUS_3 VARCHAR2(1) Yes    
PROG_CODE_4 VARCHAR2(6) Yes    
PROG_DESC_4 VARCHAR2(35) Yes    
PROG_STATUS_4 VARCHAR2(1) Yes    
PROG_CODE_5 VARCHAR2(6) Yes    
PROG_DESC_5 VARCHAR2(35) Yes    
PROG_STATUS_5 VARCHAR2(1) Yes    
ACTV_CODE VARCHAR2(6) Yes    
ACTV_DESC VARCHAR2(35) Yes    
ACTV_STATUS VARCHAR2(1) Yes    
LOCN_CODE_1 VARCHAR2(6) Yes    
LOCN_DESC_1 VARCHAR2(35) Yes    
LOCN_STATUS_1 VARCHAR2(1) Yes    
LOCN_CODE_2 VARCHAR2(6) Yes    
LOCN_DESC_2 VARCHAR2(35) Yes    
LOCN_STATUS_2 VARCHAR2(1) Yes    
LOCN_CODE_3 VARCHAR2(6) Yes    
LOCN_DESC_3 VARCHAR2(35) Yes    
LOCN_STATUS_3 VARCHAR2(1) Yes    
LOCN_CODE_4 VARCHAR2(6) Yes    
LOCN_DESC_4 VARCHAR2(35) Yes    
LOCN_STATUS_4 VARCHAR2(1) Yes    
LOCN_CODE_5 VARCHAR2(6) Yes    
LOCN_DESC_5 VARCHAR2(35) Yes    
LOCN_STATUS_5 VARCHAR2(1) Yes    
GRNT_CODE VARCHAR2(9) Yes    
GRNT_DESC VARCHAR2(35) Yes    
GRNT_STATUS VARCHAR2(2) Yes    
BANK_CODE VARCHAR2(2) Yes    
BANK_NAME VARCHAR2(60) Yes    
BANK_ACCOUNT_NAME VARCHAR2(35) Yes    
APPROVED_AMOUNT NUMBER(17,2) Yes    
ADDITIONAL_CHARGES_AMOUNT NUMBER(17,2) Yes    
TAX_AMOUNT NUMBER(17,2) Yes    
DISCOUNT_AMOUNT NUMBER(17,2) Yes    
APPROVED_CHARGE_AMOUNT NUMBER(0,0) Yes    
CURRENCY_CODE VARCHAR2(4) Yes    
CONVERTED_CHARGE_AMOUNT NUMBER(17,2) Yes    
CONVERTED_DISCOUNT_AMOUNT NUMBER(17,2) Yes    
CONVERTED_TAX_AMOUNT NUMBER(17,2) Yes    
CONVERTED_ADDITIONAL_AMOUNT NUMBER(17,2) Yes    

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GXVBANK SQL Table S10B80.GENERAL Use (select)
FAVVIC1 SQL View S10B80.BANINST1 Use (select)
F_ACCT_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_ACCT_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_ACCT_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_ACTV_STATUS_IND SQL Function S10B80.BANINST1 Call
F_ACTV_TITLE SQL Function S10B80.BANINST1 Call
F_ATYP_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_ATYP_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_ATYP_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_FTYP_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_FTYP_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_FTYP_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_FUND_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_FUND_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_FUND_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_LOCN_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_LOCN_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_LOCN_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_LOCN_TITLE SQL Function S10B80.BANINST1 Call
F_ORGN_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_ORGN_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_ORGN_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_ORGN_TITLE SQL Function S10B80.BANINST1 Call
F_PROG_HIER1_FNC SQL Function S10B80.BANINST1 Call
F_PROG_HIER2_FNC SQL Function S10B80.BANINST1 Call
F_PROG_HIER3_FNC SQL Function S10B80.BANINST1 Call
F_PROG_TITLE SQL Function S10B80.BANINST1 Call
DATE Oracle Package Type S10B80.SYS.STANDARD Rely On
NUMBER Oracle Package Type S10B80.SYS.STANDARD Rely On
VARCHAR2 Oracle Package Type S10B80.SYS.STANDARD Rely On
F_GET_FRBGRNT_STATUS_CODE Oracle Package Function S10B80.BANINST1.FRKIDEN Call
F_GET_FRBGRNT_TITLE Oracle Package Function S10B80.BANINST1.FRKIDEN Call
F_GET_SPRIDEN_ENTITY_IND Oracle Package Function S10B80.BANINST1.FRKIDEN Call
F_GET_SPRIDEN_ID Oracle Package Function S10B80.BANINST1.FRKIDEN Call
F_GET_SPRIDEN_LAST_NAME Oracle Package Function S10B80.BANINST1.FRKIDEN Call
FABINVH Oracle Synonym S10B80.PUBLIC Use (select)
FARINVA Oracle Synonym S10B80.PUBLIC Use (select)
FTVACCT Oracle Synonym S10B80.PUBLIC Use (select)
FTVCOAS Oracle Synonym S10B80.PUBLIC Use (select)
FTVFUND Oracle Synonym S10B80.PUBLIC Use (select)
GXVBANK Oracle Synonym S10B80.PUBLIC Use (select)
FABINVH SQL Table S10B80.FIMSMGR Use (select)
FARINVA SQL Table S10B80.FIMSMGR Use (select)
FTVACCT SQL Table S10B80.FIMSMGR Use (select)
FTVCOAS SQL Table S10B80.FIMSMGR Use (select)
FTVFUND SQL Table S10B80.FIMSMGR Use (select)
DECODE Oracle Package Function S10B80.SYS.STANDARD Call
NVL Oracle Package Function S10B80.SYS.STANDARD Call
SUBSTR Oracle Package Function S10B80.SYS.STANDARD Call
SYSDATE Oracle Package Function S10B80.SYS.STANDARD Call
TO_CHAR Oracle Package Function S10B80.SYS.STANDARD Call
TO_DATE Oracle Package Function S10B80.SYS.STANDARD Call

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.AF_ACCTG_DISTRIBUTION_ANALYSIS

Object Dates

Creation Date Analysis Date
04/04/2008 21:07:51:000 04/04/2008 21:57:37:000

Number of code lines

157

Number of heading comment lines

0

Number of inner comment lines

0

Columns Comments for PIDM_KEY (# 1)

Source Code Comments

This field is the internal identification number of the vendor.

Columns Comments for INVOICE_CODE_KEY (# 2)

Source Code Comments

This is the invoice document number.

Columns Comments for SUBMISSION_NUMBER_KEY (# 4)

Source Code Comments

The number of submissions allowable for a reusable/recurring document.

Columns Comments for INVOICE_ITEM_KEY (# 5)

Source Code Comments

The unique sequence number directly associated to an item on the commodity record.

Columns Comments for SEQ_NUMBER_KEY (# 6)

Source Code Comments

The unique sequence number directly associated to an invoice accounting item on the commodity record.

Columns Comments for VENDOR_ID (# 7)

Source Code Comments

This field defines the identification number used to access the vendor.

Columns Comments for VENDOR_NAME (# 8)

Source Code Comments

This field defines the name of the vendor.

Columns Comments for ENTITY_IND (# 9)

Source Code Comments

This field identifies whether record is person or non-person record. It does not display on the form. Valid values: P - person, C - non-person.

Columns Comments for PURCHASE_ORDER_NUMBER (# 10)

Source Code Comments

A user-defined or system generated document number on the purchase order.

Columns Comments for VENDOR_INV_NUMBER (# 11)

Source Code Comments

The vendors invoice code entered on the invoice document.

Columns Comments for INVOICE_DATE (# 12)

Source Code Comments

A user-defined or system generated invoice date.

Columns Comments for PAYMENT_DUE_DATE (# 13)

Source Code Comments

The date an invoice is due.

Columns Comments for CANCEL_DATE (# 14)

Source Code Comments

The date that the check was cancelled.

Columns Comments for TRANSACTION_DATE (# 15)

Source Code Comments

The date the transaction was processed.

Columns Comments for FSYR_CODE (# 16)

Source Code Comments

A unique numeric identifier code for the fiscal year being defined.

Columns Comments for FSPD_CODE (# 17)

Source Code Comments

A unique two digit numeric identifier code for the fiscal period. Usually 00 through 14.

Columns Comments for THIRD_PARTY_VENDOR_ID (# 18)

Source Code Comments

This field defines the identification number used to access the check vendor.

Columns Comments for THIRD_PARTY_VENDOR_NAME (# 19)

Source Code Comments

This field defines the name of the check vendor.

Columns Comments for THIRD_PARTY_PIDM (# 20)

Source Code Comments

The unique personal identification master of a check vendor.

Columns Comments for OPEN_PAID_IND (# 21)

Source Code Comments

Indicates if a document is open or paid.

Columns Comments for APPROVAL_IND (# 22)

Source Code Comments

Indicates if the document has been approved for processing by the individual authorized (via the user hierarchy table) to approve the document.

Columns Comments for CREDIT_MEMO_IND (# 23)

Source Code Comments

This indicator identifies invoices for which a credit memo has been processed.

Columns Comments for INVOICE_1099_IND (# 24)

Source Code Comments

This indicator distinguishes taxable payments resulting from the payment processing of the invoice. If Y (yes) the payment will be recorded and accumulated for income tax reporting purposes.

Columns Comments for INVOICE_1099_ID (# 25)

Source Code Comments

The taxpayer identification number (TIN) which uniquely identifies this vendor for Federal Income tax purposes. For an individual use the social security number.

Columns Comments for HOLD_IND (# 26)

Source Code Comments

An attribute used to place invoice records on hold to prevent disbursement to a vendor.

Columns Comments for INVOICE_TYPE_IND (# 27)

Source Code Comments

This one-character indicator designates whether an invoice is (D) for Direct Pay or (R) for Regular.

Columns Comments for COAS_CODE (# 28)

Source Code Comments

The primary identification code for any chart of accounts which is used to uniquely identify that chart from any other in a multi-chart environment.

Columns Comments for COAS_DESC (# 29)

Source Code Comments

This field specifies a free-format description of the chart of accounts

Columns Comments for COAS_STATUS (# 30)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FUND_CODE (# 31)

Source Code Comments

This field is the primary identification for the ledger fund

Columns Comments for FUND_DESC (# 32)

Source Code Comments

This field specifies a free-format description of the ledger fund

Columns Comments for ORGN_CODE (# 33)

Source Code Comments

This field is the primary identification for the ledger org

Columns Comments for ORGN_DESC (# 34)

Source Code Comments

This field specifies a free-format description of the ledger organization

Columns Comments for ACCT_CODE (# 35)

Source Code Comments

This field is the primary identification for the ledger account

Columns Comments for ACCT_DESC (# 36)

Source Code Comments

This field specifies a free-format description of the ledger account

Columns Comments for PROG_CODE (# 37)

Source Code Comments

This field specifies a free-format description of the ledger program

Columns Comments for PROG_DESC (# 38)

Source Code Comments

This field specifies a free-format description of the ledger program

Columns Comments for LOCN_CODE (# 39)

Source Code Comments

This field specifies a free-format description of the ledger location

Columns Comments for LOCN_DESC (# 40)

Source Code Comments

This field specifies a free-format description of the ledger location

Columns Comments for FUND_CODE_1 (# 41)

Source Code Comments

This field is the level 1 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_DESC_1 (# 42)

Source Code Comments

This field specifies a free-format description of the level 1 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_STATUS_1 (# 43)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FUND_CODE_2 (# 44)

Source Code Comments

This field is the level 2 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_DESC_2 (# 45)

Source Code Comments

This field specifies a free-format description of the level 2 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_STATUS_2 (# 46)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FUND_CODE_3 (# 47)

Source Code Comments

This field is the level 3 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_DESC_3 (# 48)

Source Code Comments

This field specifies a free-format description of the level 3 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_STATUS_3 (# 49)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FUND_CODE_4 (# 50)

Source Code Comments

This field is the level 4 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_DESC_4 (# 51)

Source Code Comments

This field specifies a free-format description of the level 4 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_STATUS_4 (# 52)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FUND_CODE_5 (# 53)

Source Code Comments

This field is the level 5 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_DESC_5 (# 54)

Source Code Comments

This field specifies a free-format description of the level 5 fund code within the fund code hierarchy for the ledger fund code

Columns Comments for FUND_STATUS_5 (# 55)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FTYP_CODE_1 (# 56)

Source Code Comments

This field is the level 1 fund type code within the fund type code hierarchy for the ledger fund code

Columns Comments for FTYP_DESC_1 (# 57)

Source Code Comments

This field specifies a free-format description of the level 1 fund type within the fund type hierarchy for the ledger fund code

Columns Comments for FTYP_STATUS_1 (# 58)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for FTYP_CODE_2 (# 59)

Source Code Comments

This field is the level 2 fund type code within the fund type code hierarchy for the ledger fund code

Columns Comments for FTYP_DESC_2 (# 60)

Source Code Comments

This field specifies a free-format description of the level 2 fund type for the ledger fund code

Columns Comments for FTYP_STATUS_2 (# 61)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ACCT_CODE_1 (# 62)

Source Code Comments

This field is the level 1 account code within the account code hierarchy for the ledger account code

Columns Comments for ACCT_DESC_1 (# 63)

Source Code Comments

This field specifies a free-format description of the level 1 account for the ledger account code

Columns Comments for ACCT_STATUS_1 (# 64)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ACCT_CODE_2 (# 65)

Source Code Comments

This field is the level 2 account code within the account code hierarchy for the ledger account code

Columns Comments for ACCT_DESC_2 (# 66)

Source Code Comments

This field specifies a free-format description of the level 2 account for the ledger account code

Columns Comments for ACCT_STATUS_2 (# 67)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ACCT_CODE_3 (# 68)

Source Code Comments

This field is the level 3 account code within the account code hierarchy for the ledger account code

Columns Comments for ACCT_DESC_3 (# 69)

Source Code Comments

This field specifies a free-format description of the level 3 account for the ledger account code

Columns Comments for ACCT_STATUS_3 (# 70)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ACCT_CODE_4 (# 71)

Source Code Comments

This field is the level 4 account code within the account code hierarchy for the ledger account code

Columns Comments for ACCT_DESC_4 (# 72)

Source Code Comments

This field specifies a free-format description of the level 4 account for the ledger account code

Columns Comments for ACCT_STATUS_4 (# 73)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ATYP_CODE_1 (# 74)

Source Code Comments

This field is the level 1 account type code within the account type code hierarchy for the ledger account code

Columns Comments for ATYP_DESC_1 (# 75)

Source Code Comments

This field specifies a free-format description of the level 1 account type within the account type hierarchy for the ledger account code

Columns Comments for ATYP_STATUS_1 (# 76)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ATYP_CODE_2 (# 77)

Source Code Comments

This field is the level 2 account type code within the account type code hierarchy for the ledger account code

Columns Comments for ATYP_DESC_2 (# 78)

Source Code Comments

This field specifies a free-format description of the level 2 account type for the ledger account code

Columns Comments for ATYP_STATUS_2 (# 79)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_1 (# 80)

Source Code Comments

This field is the level 1 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_1 (# 81)

Source Code Comments

This field specifies a free-format description of the level 1 account for the ledger organization code

Columns Comments for ORGN_STATUS_1 (# 82)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_2 (# 83)

Source Code Comments

This field is the level 2 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_2 (# 84)

Source Code Comments

This field specifies a free-format description of the level 2 account for the ledger organization code

Columns Comments for ORGN_STATUS_2 (# 85)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_3 (# 86)

Source Code Comments

This field is the level 3 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_3 (# 87)

Source Code Comments

This field specifies a free-format description of the level 3 account for the ledger organization code

Columns Comments for ORGN_STATUS_3 (# 88)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_4 (# 89)

Source Code Comments

This field is the level 4 organization code within organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_4 (# 90)

Source Code Comments

This field specifies a free-format description of the level 4 account for the ledger organization code

Columns Comments for ORGN_STATUS_4 (# 91)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_5 (# 92)

Source Code Comments

This field is the level 5 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_5 (# 93)

Source Code Comments

This field specifies a free-format description of the level 5 account for the ledger organization code

Columns Comments for ORGN_STATUS_5 (# 94)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_6 (# 95)

Source Code Comments

This field is the level 6 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_6 (# 96)

Source Code Comments

This field specifies a free-format description of the level 6 account for the ledger organization code

Columns Comments for ORGN_STATUS_6 (# 97)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_7 (# 98)

Source Code Comments

This field is the level 7 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_7 (# 99)

Source Code Comments

This field specifies a free-format description of the level 7 account for the ledger organization code

Columns Comments for ORGN_STATUS_7 (# 100)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ORGN_CODE_8 (# 101)

Source Code Comments

This field is the level 8 organization code within the organization code hierarchy for the ledger organization code

Columns Comments for ORGN_DESC_8 (# 102)

Source Code Comments

This field specifies a free-format description of the level 8 account for the ledger organization code

Columns Comments for ORGN_STATUS_8 (# 103)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for PROG_CODE_1 (# 104)

Source Code Comments

This field is the level 7 program code within the program code hierarchy for the ledger program code

Columns Comments for PROG_DESC_1 (# 105)

Source Code Comments

This field specifies a free-format description of the level 1 program for the ledger program code

Columns Comments for PROG_STATUS_1 (# 106)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for PROG_CODE_2 (# 107)

Source Code Comments

This field is the level 2 program code within the program code hierarchy for the ledger program code

Columns Comments for PROG_DESC_2 (# 108)

Source Code Comments

This field specifies a free-format description of the level 1 program for the ledger program code

Columns Comments for PROG_STATUS_2 (# 109)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for PROG_CODE_3 (# 110)

Source Code Comments

This field is the level 3 program code within the program code hierarchy for the ledger program code

Columns Comments for PROG_DESC_3 (# 111)

Source Code Comments

This field specifies a free-format description of the level 3 program for the ledger program code

Columns Comments for PROG_STATUS_3 (# 112)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for PROG_CODE_4 (# 113)

Source Code Comments

This field is the level 4 program code within the program code hierarchy for the ledger program code

Columns Comments for PROG_DESC_4 (# 114)

Source Code Comments

This field specifies a free-format description of the level 4 program for the ledger program code

Columns Comments for PROG_STATUS_4 (# 115)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for PROG_CODE_5 (# 116)

Source Code Comments

This field is the level 5 program code within the program code hierarchy for the ledger program code

Columns Comments for PROG_DESC_5 (# 117)

Source Code Comments

This field specifies a free-format description of the level 5 program for the ledger program code

Columns Comments for PROG_STATUS_5 (# 118)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for ACTV_CODE (# 119)

Source Code Comments

This field specifies a free-format description of the ledger activity

Columns Comments for ACTV_DESC (# 120)

Source Code Comments

This field specifies a free-format description of the ledger activity

Columns Comments for ACTV_STATUS (# 121)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for LOCN_CODE_1 (# 122)

Source Code Comments

This field is the level 1 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_DESC_1 (# 123)

Source Code Comments

This field specifies a free-format description of the level 1 location for the ledger location code

Columns Comments for LOCN_STATUS_1 (# 124)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for LOCN_CODE_2 (# 125)

Source Code Comments

This field is the level 2 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_DESC_2 (# 126)

Source Code Comments

This field specifies a free-format description of the level 2 location for the ledger location code

Columns Comments for LOCN_STATUS_2 (# 127)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for LOCN_CODE_3 (# 128)

Source Code Comments

This field is the level 3 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_DESC_3 (# 129)

Source Code Comments

This field specifies a free-format description of the level 3 location for the ledger location code

Columns Comments for LOCN_STATUS_3 (# 130)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for LOCN_CODE_4 (# 131)

Source Code Comments

This field is the level 4 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_DESC_4 (# 132)

Source Code Comments

This field is the level 4 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_STATUS_4 (# 133)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for LOCN_CODE_5 (# 134)

Source Code Comments

This field is the level 5 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_DESC_5 (# 135)

Source Code Comments

This field is the level 5 location code within the location code hierarchy for the ledger location code

Columns Comments for LOCN_STATUS_5 (# 136)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for GRNT_CODE (# 137)

Source Code Comments

This field is the grant code for the ledger fund code

Columns Comments for GRNT_DESC (# 138)

Source Code Comments

This field specifies a free-format description of the grant

Columns Comments for GRNT_STATUS (# 139)

Source Code Comments

This field is a required indicator representing the current status of a system code. A=active or I=inactive.

Columns Comments for BANK_CODE (# 140)

Source Code Comments

The user-defined value which is used to identify the bank account on all cash transactions.

Columns Comments for BANK_NAME (# 141)

Source Code Comments

The user-defined value which is used to identify the banking institution on all cash transactions.

Columns Comments for BANK_ACCOUNT_NAME (# 142)

Source Code Comments

The user-defined value which is used to identify the bank account name on all cash transactions.

Columns Comments for APPROVED_AMOUNT (# 143)

Source Code Comments

The dollar value of the invoice accounting amount on this invoice item.

Columns Comments for ADDITIONAL_CHARGES_AMOUNT (# 144)

Source Code Comments

The amount of additional charges for this invoice accounting amount on this invoice item.

Columns Comments for TAX_AMOUNT (# 145)

Source Code Comments

The amount of tax computed or entered for this invoice accounting amount on this invoice item.

Columns Comments for DISCOUNT_AMOUNT (# 146)

Source Code Comments

The dollar value of the discount being taken on the invoice accounting amount on this invoice item.

Columns Comments for APPROVED_CHARGE_AMOUNT (# 147)

Source Code Comments

This is the approved item amount, calculated by adding the approved amount, additional charge amounts and tax amounts, and then subtracting any discount amounts. Approved item amounts for credit memos will be multiplied by -1.

Columns Comments for CURRENCY_CODE (# 148)

Source Code Comments

The currency code associated with this invoice.

Columns Comments for CONVERTED_CHARGE_AMOUNT (# 149)

Source Code Comments

The base amount calculated for this accounting record. Used when a currency code is established at the header record.

Columns Comments for CONVERTED_DISCOUNT_AMOUNT (# 150)

Source Code Comments

The base discount amount calculated for this accounting record. Used when a currency code is established at the header record. Used when a currency code is established at the header record.

Columns Comments for CONVERTED_TAX_AMOUNT (# 151)

Source Code Comments

The base tax amount calculated for this accounting record. Used when a currency code is established at the header record. Used when a currency code is established at the header record.

Columns Comments for CONVERTED_ADDITIONAL_AMOUNT (# 152)

Source Code Comments

The base additional charges amount calculated for this commodity record. Used when a currency code is established at the header record.

View AF_DISBURSEMENT_ANALYSIS

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name Column Type Allow NULL PK FK
PIDM_KEY NUMBER(8,0) Yes    
INVOICE_CODE_KEY VARCHAR2(8) Yes    
SUBMISSION_NUMBER_KEY NUMBER(3,0) Yes    
CHECK_NUMBER_KEY VARCHAR2(8) No    
BANK_CODE_KEY VARCHAR2(2) No    
VENDOR_ID VARCHAR2(9) Yes    
VENDOR_NAME VARCHAR2(60) Yes    
ENTITY_IND VARCHAR2(1) Yes    
VENDOR_INVOICE_NUMBER VARCHAR2(15) Yes    
INVOICE_DATE DATE Yes    
TRANSACTION_DATE DATE Yes    
FSYR_CODE VARCHAR2(4) Yes    
FSPD_CODE VARCHAR2(2) Yes    
THIRD_PARTY_VENDOR_ID VARCHAR2(9) Yes    
THIRD_PARTY_VENDOR_NAME VARCHAR2(60) Yes    
THIRD_PARTY_PIDM NUMBER(8,0) Yes    
CREDIT_MEMO_IND VARCHAR2(1) Yes    
INVOICE_1099_IND VARCHAR2(1) Yes    
INVOICE_1099_ID VARCHAR2(9) Yes    
BANK_NAME VARCHAR2(60) Yes    
BANK_ACCOUNT_NAME VARCHAR2(35) Yes    
CHECK_TYPE VARCHAR2(1) No    
CHECK_DATE DATE Yes    
NET_AMOUNT NUMBER(17,2) Yes    
CANCEL_IND VARCHAR2(1) Yes    
CANCEL_DATE DATE Yes    
RECONCILIATION_IND VARCHAR2(1) Yes    

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GXVBANK SQL Table S10B80.GENERAL Use (select)
F_GET_FSPD_CODE SQL Function S10B80.BANINST1 Call
F_GET_FSYR_CODE SQL Function S10B80.BANINST1 Call
DATE Oracle Package Type S10B80.SYS.STANDARD Rely On
NUMBER Oracle Package Type S10B80.SYS.STANDARD Rely On
VARCHAR2 Oracle Package Type S10B80.SYS.STANDARD Rely On
F_GET_SPRIDEN_ENTITY_IND Oracle Package Function S10B80.BANINST1.FRKIDEN Call
F_GET_SPRIDEN_ID Oracle Package Function S10B80.BANINST1.FRKIDEN Call
F_GET_SPRIDEN_LAST_NAME Oracle Package Function S10B80.BANINST1.FRKIDEN Call
FABCHKS Oracle Synonym S10B80.PUBLIC Use (select)
FABINCK Oracle Synonym S10B80.PUBLIC Use (select)
FABINVH Oracle Synonym S10B80.PUBLIC Use (select)
GXVBANK Oracle Synonym S10B80.PUBLIC Use (select)
FABCHKS SQL Table S10B80.FIMSMGR Use (select)
FABINCK SQL Table S10B80.FIMSMGR Use (select)
FABINVH SQL Table S10B80.FIMSMGR Use (select)
SUBSTR Oracle Package Function S10B80.SYS.STANDARD Call
SYSDATE Oracle Package Function S10B80.SYS.STANDARD Call
TO_CHAR Oracle Package Function S10B80.SYS.STANDARD Call
TO_DATE Oracle Package Function S10B80.SYS.STANDARD Call

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.AF_DISBURSEMENT_ANALYSIS

Object Dates

Creation Date Analysis Date
04/04/2008 21:04:53:000 04/04/2008 21:57:35:000

Number of code lines

35

Number of heading comment lines

0

Number of inner comment lines

0

Columns Comments for PIDM_KEY (# 1)

Source Code Comments

This field is the internal identification number of the vendor.

Columns Comments for INVOICE_CODE_KEY (# 2)

Source Code Comments

This is the invoice document number.

Columns Comments for SUBMISSION_NUMBER_KEY (# 3)

Source Code Comments

The number of submissions allowable for a reusable/recurring document.

Columns Comments for CHECK_NUMBER_KEY (# 4)

Source Code Comments

The pre-printed check number.

Columns Comments for BANK_CODE_KEY (# 5)

Source Code Comments

The user-defined value which is used to identify the bank account on all cash transactions.

Columns Comments for VENDOR_ID (# 6)

Source Code Comments

This field defines the identification number used to access the vendor.

Columns Comments for VENDOR_NAME (# 7)

Source Code Comments

This field defines the name of the vendor.

Columns Comments for ENTITY_IND (# 8)

Source Code Comments

This field identifies whether record is person or non-person record. It does not display on the form. Valid values: P - person, C - non-person.

Columns Comments for VENDOR_INVOICE_NUMBER (# 9)

Source Code Comments

The vendors invoice code entered on the Invoice document.

Columns Comments for INVOICE_DATE (# 10)

Source Code Comments

A user-defined or system generated invoice date.

Columns Comments for TRANSACTION_DATE (# 11)

Source Code Comments

The date the transaction was processed.

Columns Comments for FSYR_CODE (# 12)

Source Code Comments

A unique numeric identifier code for the fiscal year being defined.

Columns Comments for FSPD_CODE (# 13)

Source Code Comments

A unique two digit numeric identifier code for the fiscal period. Usually 00 through 14.

Columns Comments for THIRD_PARTY_VENDOR_ID (# 14)

Source Code Comments

This field defines the identification number used to access the check vendor.

Columns Comments for THIRD_PARTY_VENDOR_NAME (# 15)

Source Code Comments

This field defines the name of the check vendor.

Columns Comments for THIRD_PARTY_PIDM (# 16)

Source Code Comments

The unique personal identification master of a check vendor.

Columns Comments for CREDIT_MEMO_IND (# 17)

Source Code Comments

This indicator identifies invoices for which a credit memo has been processed.

Columns Comments for INVOICE_1099_IND (# 18)

Source Code Comments

This indicator distinguishes taxable payments resulting from the payment processing of the invoice. If Y (yes) the payment will be recorded and accumulated for income tax reporting purposes.

Columns Comments for INVOICE_1099_ID (# 19)

Source Code Comments

The taxpayer identification number (TIN) which uniquely identifies this vendor for Federal Income tax purposes. For an individual use the social security number.

Columns Comments for BANK_NAME (# 20)

Source Code Comments

The name of banking institution where the institutionhas accounts.

Columns Comments for BANK_ACCOUNT_NAME (# 21)

Source Code Comments

The name of the bank account, i.e. Chacking Account.

Columns Comments for CHECK_TYPE (# 22)

Source Code Comments

Indicator which establishes the type of check produced. M-manual, B-batch, O-on-line.

Columns Comments for CHECK_DATE (# 23)

Source Code Comments

The date of issue for a check.

Columns Comments for NET_AMOUNT (# 24)

Source Code Comments

The net amount of an invoice.

Columns Comments for CANCEL_IND (# 25)

Source Code Comments

Indicates that the check was cancelled.

Columns Comments for CANCEL_DATE (# 26)

Source Code Comments

The date that the check was cancelled.

Columns Comments for RECONCILIATION_IND (# 27)

Source Code Comments

The indicator of whether a check or deposit record has been reconciled.

View FIVCASH

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name Column Type Allow NULL PK FK
FIVCASH_COAS_CODE VARCHAR2(1) Yes    
FIVCASH_ACCT_CODE VARCHAR2(6) Yes    

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GXVBANK SQL Table S10B80.GENERAL Use (select)
VARCHAR2 Oracle Package Type S10B80.SYS.STANDARD Rely On
GXVBANK Oracle Synonym S10B80.PUBLIC Use (select)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.FIVCASH

Object Dates

Creation Date Analysis Date
04/04/2008 21:15:07:000 04/04/2008 21:57:43:000

Number of code lines

4

Number of heading comment lines

0

Number of inner comment lines

0

Link between AF_DISBURSEMENT_ANALYSIS and GXVBANK


Link List

Link Type Link Project
Use (select) Link Between AF_DISBURSEMENT_ANALYSIS and GXVBANK BANINST1

List of Real links

Link type Between And
Use (select) AF_DISBURSEMENT_ANALYSIS GXVBANK

Link between AF_ACCTG_DISTRIBUTION_ANALYSIS and GXVBANK


Link List

Link Type Link Project
Use (select) Link Between AF_ACCTG_DISTRIBUTION_ANALYSIS and GXVBANK BANINST1

List of Real links

Link type Between And
Use (select) AF_ACCTG_DISTRIBUTION_ANALYSIS GXVBANK

Link between FIVCASH and GXVBANK


Link List

Link Type Link Project
Use (select) Link Between FIVCASH and GXVBANK BANINST1

List of Real links

Link type Between And
Use (select) FIVCASH GXVBANK

Link between PHRHIST and PHRDOCM


Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_PAY_SUMC
scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_ADJS_DOCC
scope-function : S10B80.BANINST1.BWPKHSTB.F_CHECK_IF_ADJUSTED
scope-procedure : S10B80.BANINST1.BWPKHSTB.P_GET_ORIGINAL_DATE

Link List

Link Type Link Project
Join Link Between PHRHIST and PHRDOCM PAYROLL

List of Real links

Link type Between And
Join PHRHIST PHRDOCM

Link between GTVCURR and STVNATN


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between GTVCURR and STVNATN (FK1_GTVCURR_INV_STVNATN_CODE) GENERAL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GTVCURR GTVCURR_NATION_CODE STVNATN_CODE STVNATN (0,1)-(0,n)

Link between PHRDOCM and GXVDIRD


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PHRDOCM and GXVDIRD (FK1_PHRDOCM_INV_GXVDIRD_CODE) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PHRDOCM PHRDOCM_BANK_CODE GXVDIRD_CODE_BANK_ROUT_NUM GXVDIRD (0,1)-(0,n)

Link between PEBPAYM and GXVDIRD


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PEBPAYM and GXVDIRD (FK1_PEBPAYM_INV_GXVDIRD_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PEBPAYM PEBPAYM_BANK_ROUT_NUM GXVDIRD_CODE_BANK_ROUT_NUM GXVDIRD (0,1)-(0,n)

Link between GXRDIRD and GXVDIRD


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between GXRDIRD and GXVDIRD (FK1_GXRDIRD_INV_GXVDIRD_CODE) GENERAL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GXRDIRD GXRDIRD_BANK_ROUT_NUM GXVDIRD_CODE_BANK_ROUT_NUM GXVDIRD (0,1)-(0,n)