ACCOUNT_SF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_SF_NONVW
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 Prompt Table: TERM_VAL_TBL
5	ACCOUNT_TYPE_SF	Character(3)	VARCHAR2(3) NOT NULL	Account Type Prompt Table: ACCT_TYP_TBL_SF
6	ACCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Account Status A=Active I=Inactive Default Value: A
7	OPEN_DT	Date(10)	DATE NOT NULL	Created
8	CLOSE_DT	Date(10)	DATE	Date Closed
9	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
10	ACCOUNT_BALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Account Balance
11	ACAD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Academic Year
12	LAST_AGING_DT	DateTime(26)	TIMESTAMP	Last Aging Date
13	LAST_ACCT_DT_AGED	Date(10)	DATE	Last Accounting Date Aged
14	BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Request ID Prompt Table: BI_STD_REQ_TBL
15	OVERR_BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Override Bill Request ID Prompt Table: BI_STD_REQ_TBL
16	INCLUDE_IN_BALANCE	Character(1)	VARCHAR2(1) NOT NULL	Include in Balance Y/N Table Edit Default Value: ACCT_TYP_TBL_SF.INCLUDE_IN_BALANCE
17	INCLUDE_BILLING	Character(1)	VARCHAR2(1) NOT NULL	Include Billing Y/N Table Edit Default Value: ACCT_TYP_TBL_SF.INCLUDE_BILLING
18	INCLUDE_TRANSFER	Character(1)	VARCHAR2(1) NOT NULL	Include Transfers Y/N Table Edit Default Value: ACCT_TYP_TBL_SF.INCLUDE_TRANSFER
19	INCLUDE_PREPAY	Character(1)	VARCHAR2(1) NOT NULL	Include Pre-Pay Y/N Table Edit Default Value: Y
20	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
21	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
22	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
23	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time