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
GPSC_PINTYPE_VW(SQL View) |
Index Back |
|---|---|
Element Copy Pin Type ViewElement Copy Pin Type View |
| SELECT PIN_TYPE ,DESCR FROM PS_GP_PIN_TYPE 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |