FS_CF_TMPLT_VW(SQL View) |
Index Back |
|---|---|
Chartfield Template ViewUse as the primary record of the Chartfield Template Page.. |
| SELECT %subrec(FS_CF_TMPLT_VW, A) FROM PS_FS_CF_TEMPLATE A WHERE A.CF_TYPE NOT IN ('X', 'C', 'S') AND DELETE_CF <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | CF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Type - Use specificaly for Chartfield Template.
A=Affiliate C=Currency Code D=Deleted Chartfield F=Fully Configurable P=Partially Configurable S=Statistic Code X=Product Specific Default Value: F |
| 3 | 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 |
| 4 | CF_LENGTH | Number(2,0) | SMALLINT NOT NULL | ChartField Length |
| 5 | DISPLAY_LENGTH | Number(2,0) | SMALLINT NOT NULL | Use to determine the ChartField Length to be display. |
| 6 | DELETE_CF | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit Default Value: N |
| 7 | AFFILIATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tells if the Chartfield is Intra Unit Affiliate or Inter Unit Affiliate.
A=IntraUnit Affiliate I=InterUnit Affiliate X=Standard Default Value: X |
| 8 | 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 |
| 9 | MODEL_CF | Character(18) | VARCHAR2(18) NOT NULL |
Holds the model chartfield that will be use by the CF Config Util.
Prompt Table: MODEL_CF_VW |
| 10 | ADDED_CF | Character(1) | VARCHAR2(1) NOT NULL |
Flag that will determine if the chartfield was added.
Y/N Table Edit Default Value: N |
| 11 | ORIG_CF_NAME | Character(18) | VARCHAR2(18) NOT NULL | Holds the Original Chartfield Name. This will not change! |
| 12 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 13 | ORIG_REC_NAME | Character(15) | VARCHAR2(15) NOT NULL | Original Record Name |
| 14 | CF_ORDER | Number(2,0) | SMALLINT NOT NULL | ChartField Sequence Order |
| 15 | PREV_DISPLAY_LEN | Number(2,0) | SMALLINT NOT NULL | Previous ChartField Display Length |
| 16 | PREV_CF_ORDER | Number(2,0) | SMALLINT NOT NULL | Previous ChartField Sequence Order |
| 17 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
Default Value: 0 |
| 18 | SYNCDTTM | DateTime(26) | TIMESTAMP |
Synchronization Last Update Date Time
Default Value: %datetime |