BILL_CYCLE_IDGM_CYL_SCHED_VW(SQL View) |
Index Back |
|---|---|
Grants Active Billing CyclesGrants Active Billing Cycles |
| SELECT DISTINCT A.BILL_CYCLE_ID ,A.DESCR FROM PS_GM_CYL_SCHED B ,PS_BI_CYCLE A WHERE A.STATUS_BI = 'A' AND A.BILL_CYCLE_ID = B.BILL_CYCLE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BILL_CYCLE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Billing Cycle Identifier |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |