ORIG_CF_NAMEPrompt Table: SAC_CF_PRMPT1_V
FIELDNAMEPrompt Table: SAC_CF_PRMPT1_V
TARGET_TBL_NAMEPrompt Table: SAC_PSTBL_VW
Prompt Table: SAC_CF_PRMPT3_V
SAC_CFSETUP_TBL(SQL Table) |
Index Back |
|---|---|
Chartfield setupTableChartfield setup 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!
Prompt Table: SAC_CF_PRMPT1_V |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: SAC_CF_PRMPT1_V |
| 3 | TARGET_TBL_NAME |
Character(15) | VARCHAR2(15) NOT NULL |
Target table name for chart field
Prompt Table: SAC_PSTBL_VW |
| 4 | PROMPT_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Prompt record name in Chart field template
Prompt record name in Form and Approval Builder
Prompt Table: SAC_CF_PRMPT3_V |
| 5 | ORIG_REC_NAME | Character(15) | VARCHAR2(15) NOT NULL | Original Record Name |