FM_FORM_ID_ESPEFFDTDefault Value: %date
FM_LANG_CD_ESPPrompt Table: LANGUAGE_CD_VW
Y/N Table Edit
Default Value: Y
Prompt Table: FM_ISCR_ESP_VW
Prompt Table: XML_NODE_TBL
FM_FORM_ESP(SQL Table) |
Index Back |
|---|---|
PDF Form Definition ESPPDF Form Definition ESP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FM_FORM_ID_ESP |
Character(12) | VARCHAR2(12) NOT NULL | PDF Form ID ESP |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | FM_LANG_CD_ESP |
Character(3) | VARCHAR2(3) NOT NULL |
Pdf Form Language Code ESP
Prompt Table: LANGUAGE_CD_VW |
| 4 | FM_DFLT_LANG_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Default Language
Y/N Table Edit Default Value: Y |
| 5 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 6 | FM_ISCRIPT_ESP | Character(96) | VARCHAR2(96) NOT NULL |
Pdf Form associated iScript ESP
Prompt Table: FM_ISCR_ESP_VW |
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 9 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Root node
Prompt Table: XML_NODE_TBL |