CNT_TEMPLT_ESP(SQL Table) |
Index Back |
|---|---|
SPEE Template Table ESPSPEE Template Table is used to store Contract information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: ESP Prompt Table: SET_VLD_HR_09 |
| 2 | CNT_TEMPLT_ID_ESP |
Character(11) | VARCHAR2(11) NOT NULL | SPEE Template ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 7 | FM_FORM_ID_ESP | Character(12) | VARCHAR2(12) NOT NULL | PDF Form ID ESP |
| 8 | FM_LANG_CD_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Pdf Form Language Code ESP
Default Value: ESP |
| 9 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 10 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 11 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 12 | XML_SET | Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Default Value: P01 Prompt Table: XML_SET_TBL |
| 13 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Root node
Prompt Table: XML_ROOT_VW_ESP |
| 14 | XML_TEMPLATE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Template type
Prompt Table: XML_TEMPLT_TBL |
| 15 | CNT_TEMPL_TYPE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Template Type
A=Annex C=Contract Default Value: C |
| 16 | COMMENTS | Long Character | CLOB | Comment |