PIN_TYPEPrompt Table: GP_PIN_TYPE
LANGUAGE_CDGPES_CRATYP_LNG(SQL View) |
Index Back |
|---|---|
Rel lang Rec - GPES_CRATYP_LNGRelated lan record for Pin types that can be used in element groups of type application |
| SELECT CR.PIN_TYPE , PN.LANGUAGE_CD , CR.DESCR FROM PS_GP_PIN_TYP_LANG PN , PS_GPES_CRAPTYP_VW CR WHERE PN.PIN_TYPE = CR.PIN_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Element Type
Prompt Table: GP_PIN_TYPE |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |