SETIDDefault Value: OPR_DEF_TBL_CS.SETID
Prompt Table: SP_SETID_NONVW
BILL_REQ_IDPP=Payment Plan
PRE=Pre-Payment
STU=Student
TP=Third Party
Default Value: STU
C=Organization
E=Student
Default Value: E
BI_STD_RQS_VW1(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.LASTNAME_FROM , A.LASTNAME_TO ,A.TYPE_OF_REQUEST FROM PS_BI_STD_REQ_TBL A WHERE A.TYPE_OF_REQUEST = 'E' 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 | LASTNAME_FROM | Character(15) | VARCHAR2(15) NOT NULL | Last Name FROM |
| 7 | LASTNAME_TO | Character(15) | VARCHAR2(15) NOT NULL | Last Name TO |
| 8 | TYPE_OF_REQUEST | Character(1) | VARCHAR2(1) NOT NULL |
Type of Request
C=Organization E=Student Default Value: E |