GPUS_NRP_CFV_VW

(SQL View)
 Index Back

Company Fee

Company Fee

SELECT GPUS_GRN_ID , EMPLID , GPUS_DEDSCHD , GPUS_PAY_PERIOD , GPUS_PIN_CF_NUM + 50000000 , GPUS_PIN_VAR_NUM + 50000000 , GPUS_PIN_DEDSD_NUM + 50000000 , GPUS_FLD_FMT , CURRENCY_CD , GPUS_MONVALUE , GPUS_CHARVALUE , GPUS_DECVALUE , GPUS_DATEVALUE , GPUS_FREQ ,GPUS_FREQ_FLAG , DATA_TYPE_CD FROM PS_GPUS_GRN_CFVR

# 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: 10

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
5 GPUS_PIN_CF_NUM Number(8,0) INTEGER NOT NULL Company Fee Formula PIN Number
6 GPUS_PIN_VAR_NUM Number(8,0) INTEGER NOT NULL Variable PIN Number

Prompt Table: GPUS_CFMVR_VW

7 GPUS_PIN_DEDSD_NUM Number(8,0) INTEGER NOT NULL Deduction Schedule GC PIN Number
8 GPUS_FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field Format
1=Character
2=Date
3=Monetary
4=Decimal
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 GPUS_MONVALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Monetary Value
11 GPUS_CHARVALUE Character(20) VARCHAR2(20) NOT NULL character value
12 GPUS_DECVALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Decimal Value
13 GPUS_DATEVALUE Date(10) DATE Date Value
14 GPUS_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_FREQ
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly
15 GPUS_FREQ_FLAG Character(2) VARCHAR2(2) NOT NULL Frequency Conversion Flag
16 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
N=Customer Data
S=Sample Data
Y=System Data