GPSC_PINTYPEAC=Accumulator
AE=Absence Entitlement
AT=Absence Take
BR=Bracket
DD=Deduction
EG=Element Group
ER=Earning
FM=Formula
PR=Process List
SE=Section
LANGUAGE_CDGPSC_PTYP_LNG_V(SQL View) |
Index Back |
|---|---|
Element Copy Pin Type LanguageElement Copy Pin Type Language View |
| SELECT PIN_TYPE ,LANGUAGE_CD ,DESCR FROM PS_GP_PIN_TYP_LANG TYP ,PS_GPSC_ECPY_CIDTL CIDTL WHERE TYP.PIN_TYPE=CIDTL.GPSC_PINTYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPSC_PINTYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Element Type
AC=Accumulator AE=Absence Entitlement AT=Absence Take BR=Bracket DD=Deduction EG=Element Group ER=Earning FM=Formula PR=Process List SE=Section |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |