BI_STD_REQ_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW
2	BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Request ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: BI_STD_REQ_TBL.DESCR
7	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type ID PP=Payment Plan PRE=Pre-Payment STU=Student TP=Third Party Prompt Table: BI_TYPE_TBL
8	LASTNAME_FROM	Character(15)	VARCHAR2(15) NOT NULL	Last Name FROM
9	LASTNAME_TO	Character(15)	VARCHAR2(15) NOT NULL	Last Name TO
10	CHRG_ADD_AFTER	Date(10)	DATE	Charges Added After
11	CHRG_ADD_UNTIL	Date(10)	DATE	Charges Added Until
12	MINIMUM_DIBIT_BAL	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Minimum Debit Balance
13	MINIMUM_CREDIT_BAL	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Minimum Credit Balance
14	ALL_ACCT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	All Accounts Y/N Table Edit Default Value: N
15	ALL_CAREERS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	All Careers Y/N Table Edit Default Value: N
16	ZERO_ACCT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Zero Account Y/N Table Edit Default Value: Y
17	ZERO_BILL_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Zero Bill Handling C=Create Zero Bills I=Ignore Zero Bills N=N/A U=Update Zero Bills Default Value: I
18	DAYS_ACCT_PAST_DUE	Number(3,0)	SMALLINT NOT NULL	Days Account Past Due
19	INTERNAL_COLL	Character(1)	VARCHAR2(1) NOT NULL	Interal Collections Y/N Table Edit Default Value: N
20	DAYS_PAST_DUE_FROM	Number(3,0)	SMALLINT NOT NULL	Days Past Due From
21	DAYS_PAST_DUE_TO	Number(3,0)	SMALLINT NOT NULL	Days Past Due To
22	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: CAMPUS_TBL
23	NOT_BILLED_SINCE	Date(10)	DATE	Not Billed Since
24	EXTERNAL_COLL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	External Collections Flag Default Value: N
25	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
26	DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Due Days
27	BILL_COMM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bill Comm. Flag Y/N Table Edit Default Value: N
28	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
29	COMM_CATEGORY	Character(6)	VARCHAR2(6) NOT NULL	Communication Category Prompt Table: COMM_CATG_VW2
30	COMM_CONTEXT	Character(6)	VARCHAR2(6) NOT NULL	Communication Context Prompt Table: COMM_CA_CTX_VW
31	TYPE_OF_REQUEST	Character(1)	VARCHAR2(1) NOT NULL	Type of Request C=Organization E=Student Default Value: E
32	CORPORATION_FROM	Character(30)	VARCHAR2(30) NOT NULL	Corporation From
33	CORPORATION_TO	Character(30)	VARCHAR2(30) NOT NULL	Corporation To
34	PRT_CLASS_SCHEDULE	Character(1)	VARCHAR2(1) NOT NULL	Print Schedule of Classes Y/N Table Edit Default Value: N
35	IVC_NUM_ID	Character(8)	VARCHAR2(8) NOT NULL	Invoice ID Number Prompt Table: BI_IVC_NUM_VW
36	BI_SCAN_LINE_DEF	Character(8)	VARCHAR2(8) NOT NULL	Billing Scan Line Definition Prompt Table: BI_SCAN_LINE
37	ACCT_STATEMENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	View Account Detail Y/N Table Edit Default Value: Y
38	INVOICE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create Invoices A=Create Account Statements C=Create Credit Invoices I=Create Invoices Default Value: I
39	BI_PRIOR_INV_CALC	Character(1)	VARCHAR2(1) NOT NULL	Prior Invoice Calc Option 1=Use Prior Invoice Amount 2=Account Balance Method
40	ALT_BILLING_CM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Additional Bill Communication Y/N Table Edit Default Value: N
41	SCC_LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter Code Prompt Table: SCC_STN_LTR_TBL
42	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
43	LS_CONTACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contact Type Prompt Table: ORG_CNT_TYP_TBL
44	USE_ADMISSIONS	Character(1)	VARCHAR2(1) NOT NULL	Use Admissions Y/N Table Edit Default Value: N
45	USE_RECORDS	Character(1)	VARCHAR2(1) NOT NULL	Use Records Y/N Table Edit Default Value: Y
46	ALL_GROUPS	Character(1)	VARCHAR2(1) NOT NULL	All Groups Y/N Table Edit Default Value: Y
47	CURRENT_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Current Table Entries Only Y/N Table Edit Default Value: N
48	SERVICE_IMPACT	Character(5)	VARCHAR2(5) NOT NULL	Service Impact Prompt Table: SSF_SVCIMP_DVW2
49	ACAD_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Academic Group Prompt Table: ACAD_GROUP_TBL
50	ACAD_PLAN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Academic Plan Type CON=Concentration COS=Course of Study HON=Honors MAJ=Major MIN=Minor PRP=Preparation RTC=ROTC SP=Specialization
51	ACADEMIC_LOAD	Character(1)	VARCHAR2(1) NOT NULL	Academic Load F=Enrolled Full-Time H=Enrolled Half-Time L=Less than Half-Time N=No Unit Load P=Enrolled Part-Time T=Three Quarter Time
52	ACAD_LOAD_APPR	Character(1)	VARCHAR2(1) NOT NULL	Approved Academic Load B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time
53	TUITION_RES	Character(5)	VARCHAR2(5) NOT NULL	Tuition Residency Prompt Table: RESIDENCY_TBL
54	FORM_OF_STUDY	Character(4)	VARCHAR2(4) NOT NULL	Form of Study ABRD=Study Abroad CAND=Advanced to Candidacy DTCH=Detached Study ENRL=Class Enrollment
55	ACAD_LEVEL_BOT	Character(3)	VARCHAR2(3) NOT NULL	Academic Level - Term Start Prompt Table: XL_ACAD_LVL_VW
56	ACAD_LEVEL_PROJ	Character(3)	VARCHAR2(3) NOT NULL	Academic Level - Projected Prompt Table: XL_ACAD_LVL_VW
57	SSF_ALL_BLKS	Character(1)	VARCHAR2(1) NOT NULL	All Blocks Y/N Table Edit Default Value: Y
58	SSF_EURO_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Apply Payments by Invoice Y/N Table Edit