FS_CF_PROD_LOG(SQL Table) |
Index Back |
|---|---|
Product Action Status table |
| # | 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 | PS_PRODUCT |
Character(18) | VARCHAR2(18) NOT NULL | PeopleSoft Product |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | 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 |
| 6 | 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 |
| 7 | DTTIME_LAST_MAINT | DateTime(26) | TIMESTAMP | Date Time Last Maintained |