HMCF_CFS_REC_VW(SQL View) |
Index Back |
|---|---|
Dynamic ChartFieldsUsed for displaying ChartFields on Pages |
| SELECT '1' ,'2' ,'3' ,'4' ,'5' ,'6' ,'7' ,'8' ,'9' ,'10' ,'11' ,'12' ,'13' ,'14' ,'15' ,'16' ,'17' ,'18' ,'19' ,'20' ,'21' FROM PS_INSTALLATION WHERE PC = 'X' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CF_VALUE_1 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: GL_ACCOUNT_TBL |
| 2 | CF_VALUE_2 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: DEPT_CF_TBL |
| 3 | CF_VALUE_3 | Character(15) | VARCHAR2(15) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: PROJ_ALL_VW |
| 4 | CF_VALUE_4 | Character(6) | VARCHAR2(6) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: PRODUCT_TBL |
| 5 | CF_VALUE_5 | Character(5) | VARCHAR2(5) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: FUND_TBL |
| 6 | CF_VALUE_6 | Character(5) | VARCHAR2(5) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: PROGRAM_TBL |
| 7 | CF_VALUE_7 | Character(5) | VARCHAR2(5) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: CLASS_CF_TBL |
| 8 | CF_VALUE_8 | Character(5) | VARCHAR2(5) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: BUS_UNIT_TBL_GL |
| 9 | CF_VALUE_9 | Character(8) | VARCHAR2(8) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: OPER_UNIT_TBL |
| 10 | CF_VALUE_10 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: ALTACCT_TBL |
| 11 | CF_VALUE_11 | Character(8) | VARCHAR2(8) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: BUD_REF_TBL |
| 12 | CF_VALUE_12 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: CHARTFIELD1_TBL |
| 13 | CF_VALUE_13 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: CHARTFIELD2_TBL |
| 14 | CF_VALUE_14 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: CHARTFIELD3_TBL |
| 15 | CF_VALUE_15 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: %EDIT_PROJECT |
| 16 | CF_VALUE_16 | Character(10) | VARCHAR2(10) NOT NULL |
DERIVED CHARTFIELD. DO NO USE ON A SQL TABLE
Prompt Table: %EDIT_ACTIVITY |
| 17 | CF_VALUE_17 | Character(5) | VARCHAR2(5) NOT NULL |
Configurable Generic ChartField.
This field is subject to programmatic modifications to stay matched up with the ChartField configuration.
DO NOT use this field on a SQL table or a view.
Prompt Table: %EDIT_RESOURCE |
| 18 | CF_VALUE_18 | Character(5) | VARCHAR2(5) NOT NULL |
Configurable Generic ChartField.
This field is subject to programmatic modifications to stay matched up with the ChartField configuration.
DO NOT use this field on a SQL table or a view.
Prompt Table: CHARTFIELD3_TBL |
| 19 | CF_VALUE_19 | Character(5) | VARCHAR2(5) NOT NULL |
Configurable Generic ChartField.
This field is subject to programmatic modifications to stay matched up with the ChartField configuration.
DO NOT use this field on a SQL table or a view.
Prompt Table: CHARTFIELD2_TBL |
| 20 | CF_VALUE_20 | Character(5) | VARCHAR2(5) NOT NULL | Configurable Generic ChartField. This field is subject to programmatic modifications to stay matched up with the ChartField configuration. DO NOT use this field on a SQL table or a view. |
| 21 | CF_VALUE_21 | Character(5) | VARCHAR2(5) NOT NULL | Configurable Generic ChartField. This field is subject to programmatic modifications to stay matched up with the ChartField configuration. DO NOT use this field on a SQL table or a view. |