BI_STD_RQS_VW2

(SQL View)
 Index Back

Billing Standard Request Table


SELECT A.SETID , A.BILL_REQ_ID , A.BILL_TYPE_ID , A.ALL_ACCT_FLAG , A.ALL_CAREERS_FLAG , A.CORPORATION_FROM , A.CORPORATION_TO , A.TYPE_OF_REQUEST FROM PS_BI_STD_REQ_TBL A WHERE A.TYPE_OF_REQUEST = 'C' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BI_STD_REQ_TBL WHERE A.SETID = SETID AND A.BILL_REQ_ID = BILL_REQ_ID AND EFFDT <= %CurrentDateIn ) AND EFF_STATUS = 'A'

# 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 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type ID
PP=Payment Plan
PRE=Pre-Payment
STU=Student
TP=Third Party

Default Value: STU

4 ALL_ACCT_FLAG Character(1) VARCHAR2(1) NOT NULL All Accounts
5 ALL_CAREERS_FLAG Character(1) VARCHAR2(1) NOT NULL All Careers
6 CORPORATION_FROM Character(30) VARCHAR2(30) NOT NULL Corporation From
7 CORPORATION_TO Character(30) VARCHAR2(30) NOT NULL Corporation To
8 TYPE_OF_REQUEST Character(1) VARCHAR2(1) NOT NULL Type of Request
C=Organization
E=Student

Default Value: E