GPBR_NRP_RA9_VW

(SQL View)
Index Back

RAIS paramaters.

RAIS parameters.

SELECT COMPANY ,EFFDT ,GPBR_RAIS_TER_TYPE ,GPBR_ENTRY_TYPE ,PIN_NUM + 50000000 ,GPBR_SIGN_USE ,GPBR_SIGN_NBR FROM PS_GPBR_PARM_RAIS9

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 GPBR_RAIS_TER_TYPE Character(2) VARCHAR2(2) NOT NULL RAIS Termination Payment Type
10=Indemnified Vacations
20=Bank of Hours
30=Union Adjustment
40=Other Compensations
50=FGTS Fine

Default Value: 10

4 GPBR_ENTRY_TYPE Character(2) VARCHAR2(2) NOT NULL Entry type element
10=Earnings
20=Deductions

Default Value: 10

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %EDITTABLE9

6 GPBR_SIGN_USE Character(1) VARCHAR2(1) NOT NULL Sign Use
A=Add
S=Substract

Default Value: A

7 GPBR_SIGN_NBR Signed Number(3,0) DECIMAL(2) NOT NULL Sign number