GPBR_RTPA_WRK

(SQL Table)
 Index Back

Temp Table DIRF RTPA

Temporary table to process RTPA register in DIRF 2017 layout. For each INFPA register there must exist a subsequent RTPA register in the electronic file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
5 GPBR_AMT_01 Signed Number(20,6) DECIMAL(18,6) NOT NULL January Amount
6 GPBR_AMT_02 Signed Number(20,6) DECIMAL(18,6) NOT NULL February Amount
7 GPBR_AMT_03 Signed Number(20,6) DECIMAL(18,6) NOT NULL March Amount
8 GPBR_AMT_04 Signed Number(20,6) DECIMAL(18,6) NOT NULL April Amount
9 GPBR_AMT_05 Signed Number(20,6) DECIMAL(18,6) NOT NULL May Amount
10 GPBR_AMT_06 Signed Number(20,6) DECIMAL(18,6) NOT NULL June Amount
11 GPBR_AMT_07 Signed Number(20,6) DECIMAL(18,6) NOT NULL Jully Amount
12 GPBR_AMT_08 Signed Number(20,6) DECIMAL(18,6) NOT NULL Jully Amount
13 GPBR_AMT_09 Signed Number(20,6) DECIMAL(18,6) NOT NULL September Amount
14 GPBR_AMT_10 Signed Number(20,6) DECIMAL(18,6) NOT NULL October Amount
15 GPBR_AMT_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL November Amount
16 GPBR_AMT_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL December Amount
17 GPBR_AMT_13 Signed Number(20,6) DECIMAL(18,6) NOT NULL 13th Salary