BI_ACCT_TEMP

(SQL Table)
Index Back

Billing View

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
4 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
5 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

Prompt Table: ACCT_TYP_TBL_SF

6 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
7 ACCOUNT_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Account Balance
8 BILL_REQ_ID Character(10) VARCHAR2(10) NOT NULL Bill Request ID
9 OVERR_BILL_REQ_ID Character(10) VARCHAR2(10) NOT NULL Override Bill Request ID
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 DT_OF_DEATH Date(10) DATE Date of Death