GPCH_FM_FORM_IDEFFDTDefault Value: %date
GPCH_FM_LANG_CDPrompt Table: LANGUAGE_CD_VW
Y/N Table Edit
Default Value: Y
GPCH_FM_FORM(SQL Table) |
Index Back |
|---|---|
GPCH_FM_FORMStores attached Forms for LAW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_FM_FORM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Form ID. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPCH_FM_LANG_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Form Language Code
Prompt Table: LANGUAGE_CD_VW |
| 4 | GPCH_FM_DFLT_LANG | Character(3) | VARCHAR2(3) NOT NULL |
Tax Statment Form default Language
Y/N Table Edit Default Value: Y |
| 5 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 6 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 7 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 8 | GPCH_FM_XML | Long Character(32000) | CLOB | Form /XML |