GPUS_CF_VW

(SQL View)
 Index Back

Calculation Rule

Calculation Rule View

SELECT A.EMPLID , A.GPUS_GRN_ID , A.GPUS_DEDSCHD , A.GPUS_PIN_CF_NUM , A.GPUS_PAY_PERIOD , B.GPUS_PIN_VAR_NUM , B.GPUS_FLD_FMT , B.GPUS_DECVALUE , B.GPUS_MONVALUE , B.CURRENCY_CD , A.GPUS_COMP_FEEIND , B.GPUS_FREQ ,B.GPUS_FREQ_FLAG FROM PS_GPUS_GRN_CALC A , PS_GPUS_GRN_CFVR B WHERE A.EMPLID = B.EMPLID AND A.GPUS_GRN_ID = B.GPUS_GRN_ID AND A.GPUS_PAY_PERIOD = B.GPUS_PAY_PERIOD AND A.GPUS_PIN_CF_NUM = B.GPUS_PIN_CF_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 GPUS_GRN_ID Character(16) VARCHAR2(16) NOT NULL GPUS_GARNID
3 GPUS_DEDSCHD Character(2) VARCHAR2(2) NOT NULL Deduction Schedule
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly
50=All Payrolls
4 GPUS_PIN_CF_NUM Number(8,0) INTEGER NOT NULL Company Fee Formula PIN Number
5 GPUS_PAY_PERIOD Character(1) VARCHAR2(1) NOT NULL Pay Period
0=1-All
1=1-First
2=2-Second
3=3-Third
4=4-Fourth
5=5-Fifth
6 GPUS_PIN_VAR_NUM Number(8,0) INTEGER NOT NULL Variable PIN Number
7 GPUS_FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field Format
1=Character
2=Date
3=Monetary
4=Decimal
8 GPUS_DECVALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Decimal Value
9 GPUS_MONVALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Monetary Value
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 GPUS_PAY_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_PAYFEEIND
N=No
Y=Yes
12 GPUS_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_FREQ
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly
13 GPUS_FREQ_FLAG Character(2) VARCHAR2(2) NOT NULL Frequency Conversion Flag