CF_ORDERA=Active ChartField
I=Inactive ChartField
TL_CF_TMPLT_VW(SQL View) |
Index Back |
|---|---|
TL view against FS CF TMPLTView against FS CF TMPLT VW retrieving CFs in their CF order |
| SELECT CF_ORDER , ORIG_CF_NAME , CF_ACTIVE_STATUS , ' ' FROM PS_FS_CF_TMPLT_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CF_ORDER |
Number(2,0) | SMALLINT NOT NULL | ChartField Sequence Order |
| 2 | ORIG_CF_NAME | Character(18) | VARCHAR2(18) NOT NULL | Holds the Original Chartfield Name. This will not change! |
| 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 I=Inactive ChartField |
| 4 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |