HGA_TAKE_ACM_VW

(SQL View)
 Index Back

Absence Take Acumulator PIN

PIN_CODE and Pin Num of Take Accumulator which is created as auto generated accumulators for an Entitlment name. The Name of the take accumulator = Entitlement Name + Seperator + Suffix (take) PIN CODE = Name + [Space] + Country

SELECT PIN1.PIN_NUM , PIN.PIN_NUM , CMP.PIN_ENTL_BAL_NUM , PIN.PIN_NM %Concat %Coalesce(S.SUFFIX_SEPARATOR %Concat S.TAKE_ACM_SFX , X.SUFFIX_SEPARATOR %Concat X.TAKE_ACM_SFX) %Concat ' ' %Concat PIN.COUNTRY , PIN.COUNTRY , 'T' 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.TAKE_ACM_SFX , X.SUFFIX_SEPARATOR %concat X.TAKE_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_TK_NUM Number(8,0) INTEGER NOT NULL Element number field
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