KK_XCP_BD_CFVW3(SQL View) |
Index Back |
|---|---|
Budget CF names, labels, prmptUsed for display to list BU, Acct, then all Budget Chartfields from CFCC1_AN_SBR (includes budget period). |
| SELECT DISTINCT B.FIELD_SEQUENCE , B.CHARTFIELD , C.LONGNAME , B.RECNAME , B.RECNAME_NO_EFFDT FROM PSDBFLDLABL_VW C , PS_LED_GRP_FLD_TBL B , PS_LED_GRP_LED_TBL A WHERE (B.CHARTFIELD = 'ACCOUNT' OR B.CHARTFIELD = 'BUSINESS_UNIT' OR EXISTS ( SELECT 'X' FROM PSRECFIELD D WHERE D.RECNAME ='CFCC1_AN_SBR' AND D.FIELDNAME = B.CHARTFIELD)) AND B.CHARTFIELD = C.FIELDNAME AND A.LEDGER_TYPE_KK > ' ' AND A.SETID = B.SETID AND A.LEDGER_GROUP = B.LEDGER_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 2 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 3 | CF_LABEL | Character(30) | VARCHAR2(30) NOT NULL | ChartField Name |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | RECNAME_NO_EFFDT | Character(15) | VARCHAR2(15) NOT NULL | View - No Effective Date |