GPBR_ACMTYPE_VW

(SQL View)
 Index Back

Accummulators By Type View

Accummulators By Type View

SELECT A.PIN_NUM ,B.PIN_NM ,A.CALC_TYPE ,A.entry_type_user_k1 ,A.entry_type_user_k2 ,A.entry_type_user_k3 ,A.entry_type_user_k4 ,A.entry_type_user_k5 ,A.entry_type_user_k6 ,a.PIN_USER_KEY1_NUM ,a.PIN_USER_KEY2_NUM ,a.PIN_USER_KEY3_NUM ,a.PIN_USER_KEY4_NUM ,a.PIN_USER_KEY5_NUM ,a.PIN_USER_KEY6_NUM FROM PS_GP_ACCUMULATOR a ,ps_gp_pin b WHERE a.pin_num=b.pin_num AND b.country='BRA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
3 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation
4 ENTRY_TYPE_USER_K1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
5 ENTRY_TYPE_USER_K2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
6 ENTRY_TYPE_USER_K3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
7 ENTRY_TYPE_USER_K4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
8 ENTRY_TYPE_USER_K5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
9 ENTRY_TYPE_USER_K6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
10 PIN_USER_KEY1_NUM Number(8,0) INTEGER NOT NULL Element number field
11 PIN_USER_KEY2_NUM Number(8,0) INTEGER NOT NULL Element number field
12 PIN_USER_KEY3_NUM Number(8,0) INTEGER NOT NULL Element number field
13 PIN_USER_KEY4_NUM Number(8,0) INTEGER NOT NULL Element number field
14 PIN_USER_KEY5_NUM Number(8,0) INTEGER NOT NULL Element number field
15 PIN_USER_KEY6_NUM Number(8,0) INTEGER NOT NULL Element number field