FT_CFVS_PRC_AET(SQL Table) |
Index Back |
|---|---|
CF ValueSet State RecordChartfield ValueSet State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 4 | CFV_SET | Character(20) | VARCHAR2(20) NOT NULL | ChartField Value Set |
| 5 | CFV_SETID | Character(5) | VARCHAR2(5) NOT NULL | ChartField Valuse Set SetID |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | HOW_FIELD_SPECIFY | Character(1) | VARCHAR2(1) NOT NULL |
How Specified
1=All Detail Values 2=Selected Detail Values 3=Detail - Selected Parents 4=Selected Tree Nodes 5=Children at a Level 6=All Nodes at Selected Levels 7=Selected Summary ChrtFld Nodes 9=Value Mask A=Account Type R=Range of Values |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 9 | SETID_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 10 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 11 | TAO_TBL_NAME | Character(15) | VARCHAR2(15) NOT NULL | Base TAO Table Name |
| 12 | SQLROWS_TAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 13 | PROCESS_STEP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Process Step Flag |
| 14 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |