HGA_ENTL_ACM_VW(SQL View) |
Index Back |
|---|---|
Absence Take Acumulator PINPIN_CODE and Pin Num of Entitlement Accumulator which is created as auto generated accumulators for an Entitlement Element The Name of the Entitlement accumulator = Entitlement Name + Seperator + Suffix (Entl) PIN CODE = Name + [Space] + Country |
| SELECT PIN1.PIN_NUM , PIN.PIN_NUM , CMP.PIN_ENTL_BAL_NUM , PIN1.PIN_CODE , PIN.COUNTRY , 'E' FROM PS_GP_PIN PIN LEFT OUTER JOIN PS_GP_SUFFIX S ON PIN.COUNTRY = S.COUNTRY , PS_GP_SUFFIX X , PS_GP_PIN PIN1 , PS_GP_PIN_CMPNT CMP WHERE X.DFLT_CTRY_IND = 'Y' AND PIN.PIN_TYPE = 'AE' AND PIN1.PIN_PARENT_NUM = PIN.PIN_NUM AND PIN1.PIN_CODE = PIN.PIN_NM %Concat %Coalesce(S.SUFFIX_SEPARATOR %concat S.ENTL_ACM_SFX , X.SUFFIX_SEPARATOR %concat X.ENTL_ACM_SFX) %Concat ' ' %Concat PIN.COUNTRY AND CMP.PIN_NUM = PIN.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | PIN_ENT_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 3 | PIN_ENTL_BAL_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 4 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | ABS_AC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Absence Accumlator Type (Balance or Take).
B=Balance E=Entitlement T=Take |