FS_CF_ACT_2_LOG(SQL Table) |
Index Back |
|---|---|
ChartField Template Sub-ActionChartField Template Secondary Actions log. Used for secondary actions like rebuild index, recreate SQL Objects as a result of a primary action (Activate/Ina |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ORIG_CF_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Holds the Original Chartfield Name. This will not change! |
| 2 | CF_TMPLT_ACTION |
Character(1) | VARCHAR2(1) NOT NULL |
Defines the Chartfield Template Action.
A=Add B=Add IntraUnit Affiliate D=Delete E=Delete IntraUnit Affiliate I=Inactivate/Activate L=Relabel N=Rename O=Rename IntraUnit Affiliate R=Resequence S=Resize X=Change Related IntraUnit Aff Z=Change Display Size |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | CF_ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option.
A=Active ChartField D=Delete I=Inactive ChartField |
| 5 | NEW_CF_NAME | Character(18) | VARCHAR2(18) NOT NULL | New ChartField Name |
| 6 | NEW_CF_LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 7 | NEW_DISP_LENGTH | Number(2,0) | SMALLINT NOT NULL | New Display Length |
| 8 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 9 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 10 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |
| 11 | PROMPT_TBL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Prompt Table Flag |
| 12 | NEW_ACTION | Character(1) | VARCHAR2(1) NOT NULL | New Action Flag |
| 13 | CF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Define the Chartfield Action Status
C=Complete N=Not yet begun P=Not yet begun U=Auto Configuration Complete |
| 14 | PREV_ACTION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
If there is a Previous Action request for ChartField configuration then this should be "Y".
Y/N Table Edit Default Value: N |
| 15 | MODEL_CF | Character(18) | VARCHAR2(18) NOT NULL | Holds the model chartfield that will be use by the CF Config Util. |
| 16 | AFF_RELATED_CF | Character(18) | VARCHAR2(18) NOT NULL |
Holds the Related Chartfield that is needed by Affiliate Chartfield.
Prompt Table: AFF_CF_PRMPT_VW |
| 17 | PREV_RELATED_CF | Character(18) | VARCHAR2(18) NOT NULL | Holds the previous Affiliate Related Chartfield if the Affiliate Related Chartfield changes. |
| 18 | DTTIME_LAST_MAINT | DateTime(26) | TIMESTAMP | Date Time Last Maintained |