GPFR_DADS_TMP1

(SQL Table)
Index Back

Payee Report working table

Working table for the Payee Report process run (preparation of the pay results for reporting)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
10 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
11 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
12 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
13 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record
14 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
15 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field
16 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
17 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
18 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
19 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
20 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
21 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
22 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
23 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
24 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
25 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
26 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
27 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
28 PIN_CUSTOM2 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM2
29 PIN_CUSTOM3 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM3 fields
30 PIN_CUSTOM4 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM4
31 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5
32 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
33 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
34 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
35 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
36 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
37 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
38 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
39 GPFR_DA_SIGN_IND Character(1) VARCHAR2(1) NOT NULL Sign Indicator
A=Add
S=Subtract