MODEL_CF_VW(SQL View) |
Index Back |
---|---|
Affiliate Chartfield PromptPrompt for Affiliate Chartfield |
SELECT FIELDNAME FROM PS_FS_CF_TEMPLATE WHERE CF_TYPE <> 'D' AND CF_TYPE = 'F' AND CF_ACTIVE_STATUS = 'A' AND AFFILIATE_TYPE = 'X' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |