GP_ABS_SEC_COUNTRYGP_ABS_CS_SEC_IDLANGUAGE_CDGP_ABS_SECVWLNG(SQL View) |
Index Back |
|---|---|
Related-language recordConfigurable Sections: The Related-language record for AbsenceTemplate Section Setup Table is where the meta-data for each template section is stored. |
| SELECT COUNTRY , GP_ABS_CS_SEC_ID , LANGUAGE_CD , DESCRSHORT , DESCR50 , DESCRLONG FROM %Table(GP_ABS_SECD_LNG) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_ABS_SEC_COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Section Country |
| 2 | GP_ABS_CS_SEC_ID |
Character(18) | VARCHAR2(18) NOT NULL | Template Section ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |