FS_CF_UPD_AET(SQL Table) |
Index Back |
|---|---|
Chartfield Configuration Cache |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | ACTION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Flag
A=Action |
| 5 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 6 | PROJECTNAME_EXCL | Character(30) | VARCHAR2(30) NOT NULL | Project Name |
| 7 | ORIG_CF_NAME | Character(18) | VARCHAR2(18) NOT NULL | Holds the Original Chartfield Name. This will not change! |
| 8 | 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 |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 10 | FIELDNAME_RLTD | Character(18) | VARCHAR2(18) NOT NULL | Related Field |
| 11 | MODEL_CF | Character(18) | VARCHAR2(18) NOT NULL | Holds the model chartfield that will be use by the CF Config Util. |
| 12 | NEW_CF_NAME | Character(18) | VARCHAR2(18) NOT NULL | New ChartField Name |
| 13 | NEW_CF_LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 14 | NEW_DISP_LENGTH | Number(2,0) | SMALLINT NOT NULL | New Display Length |
| 15 | PROMPT_TBL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Prompt Table Flag |
| 16 | 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 Default Value: A |
| 17 | NEW_ACTION | Character(1) | VARCHAR2(1) NOT NULL | New Action Flag |
| 18 | OUTPUTDEST | Character(127) | VARCHAR2(127) NOT NULL | Output Destination |
| 19 | PS_PRODUCT | Character(18) | VARCHAR2(18) NOT NULL | PeopleSoft Product |
| 20 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 21 | SEQUENCE_NBR_6B | Number(6,0) | INTEGER NOT NULL | Sequence B |
| 22 | CF_PROJECT | Character(15) | VARCHAR2(15) NOT NULL | CF Configuration ID |
| 23 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 24 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 25 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |
| 26 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 27 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 28 | PROJ_ARRAY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Array Flag |
| 29 | CF_RUN_FULL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Run Full Configuration flag to specify if the Run Full Configuration option in the Process Request is selected.
Y/N Table Edit Default Value: N |
| 30 | CF_STEP_NBR | Number(6,0) | INTEGER NOT NULL |
Step Number
Default Value: 1 |
| 31 | AFF_RELATED_CF | Character(18) | VARCHAR2(18) NOT NULL | Holds the Related Chartfield that is needed by Affiliate Chartfield. |
| 32 | PREV_RELATED_CF | Character(18) | VARCHAR2(18) NOT NULL | Holds the previous Affiliate Related Chartfield if the Affiliate Related Chartfield changes. |
| 33 | RUN_CNTL_ID_DEMO | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 34 | SEQ_NBR_4 | Number(4,0) | SMALLINT NOT NULL | Sequence Nbr 4 |
| 35 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 36 | CF_OBJ_ID | Signed Number(11,0) | DECIMAL(10) NOT NULL | used for storing OBJECT_ID(table) values for MS SQL Server and Sybase |
| 37 | RECNAME_18 | Character(18) | VARCHAR2(18) NOT NULL | used in table CFOBJECT_TMP for App Engine FS_CFUPDATE.ViewSrch to look for view/table dependencies. |
| 38 | CF_ORDER | Number(2,0) | SMALLINT NOT NULL | ChartField Sequence Order |
| 39 | UPG_CFCONFIG_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used in CF Configuration if the process is running in an upgrade environment |
| 40 | FIELDLIST | Character(254) | VARCHAR2(254) NOT NULL | Used to store a list of FieldNames |