GPUS_NRP_CAL_VW

(SQL View)
 Index Back

Garnishment Calculation

Garnishment Calculation

SELECT GPUS_GRN_ID , EMPLID , GPUS_DEDSCHD , GPUS_PAY_PERIOD , GPUS_PIN_PF_NUM + 50000000 , GPUS_PIN_CF_NUM + 50000000 , GPUS_PIN_CAL_NUM + 50000000 , GPUS_PIN_DEDSD_NUM , GPUS_FREQ , GPUS_PF_FREQ , GPUS_CF_FREQ , GPUS_PAY_FEEIND , GPUS_COMP_FEEIND , DATA_TYPE_CD FROM PS_GPUS_GRN_CALC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPUS_GRN_ID Character(16) VARCHAR2(16) NOT NULL GPUS_GARNID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 GPUS_DEDSCHD Character(2) VARCHAR2(2) NOT NULL Deduction Schedule
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly
50=All Payrolls

Default Value: 50

4 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

Default Value: 0

5 GPUS_PIN_PF_NUM Number(8,0) INTEGER NOT NULL Recipient Fee Formula PIN Number

Prompt Table: GPUS_PFMTHD_VW

6 GPUS_PIN_CF_NUM Number(8,0) INTEGER NOT NULL Company Fee Formula PIN Number for Garnishments

Prompt Table: GPUS_CFMTHD_VW

7 GPUS_PIN_CAL_NUM Number(8,0) INTEGER NOT NULL Calculation Formula PIN Number

Prompt Table: GPUS_CALMTHD_VW

8 GPUS_PIN_DEDSD_NUM Number(8,0) INTEGER NOT NULL Deduction Schedule GC PIN Number

Prompt Table: GPUS_GC_VW

9 GPUS_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_FREQ
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly

Default Value: 10

10 GPUS_PF_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_PFEEFREQ
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly

Default Value: 10

11 GPUS_CF_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_CFEEFREQ
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly

Default Value: 10

12 GPUS_PAY_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_PAYFEEIND
N=No
Y=Yes
13 GPUS_COMP_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_COMPFEEIND
N=No
Y=Yes
14 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data