CONTRACT_NUMBILL_PLAN_IDCA_SRCH_BP_VW(SQL View) |
Index Back |
|---|---|
BP Specialist and Authority |
| SELECT PLN.CONTRACT_NUM , PLN.BILL_PLAN_ID , PLN.BILLING_SPECIALIST , PLN.BILLING_AUTHORITY , CRL.SETID FROM PS_SET_CNTRL_REC CRL , PS_CA_BILL_PLAN PLN WHERE CRL.SETCNTRLVALUE = PLN.BUSINESS_UNIT_BI AND CRL.RECNAME = 'BI_SPECIALIST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | BILL_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 3 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 4 | BILLING_AUTHORITY | Character(8) | VARCHAR2(8) NOT NULL | Billing Authority |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |