GPDE_FM_FORM_IDEFFDTDefault Value: %date
GPDE_FM_LANG_CDPrompt Table: LANGUAGE_CD_VW
Y/N Table Edit
Default Value: Y
Prompt Table: GPDE_FM_VAL_VW
Prompt Table: GPDE_FM_ISCR_VW
GPDE_FM_FORM(SQL Table) |
Index Back |
|---|---|
CT Forms Tableholds information about file location and javascripts used against this form |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_FM_FORM_ID |
Character(12) | VARCHAR2(12) NOT NULL | ID of PDF Form |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPDE_FM_LANG_CD |
Character(3) | VARCHAR2(3) NOT NULL |
language code of Form
Prompt Table: LANGUAGE_CD_VW |
| 4 | GPDE_FM_DFLT_LANG | Character(3) | VARCHAR2(3) NOT NULL |
Default language of stored PDF Form
Y/N Table Edit Default Value: Y |
| 5 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: GPDE_FM_VAL_VW |
| 6 | GPDE_FM_ISCRIPT | Character(96) | VARCHAR2(96) NOT NULL |
Function Container for Iscript
Prompt Table: GPDE_FM_ISCR_VW |
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |