GPFR_RSLT_TMP

(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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
12 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
13 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
14 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record
15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
16 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application
17 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID
18 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set
19 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field
20 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
21 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
22 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
23 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
24 GPFR_AMOUNT_SIGN Signed Number(4,0) DECIMAL(3) NOT NULL Amount Sign
25 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
26 GPFR_BASE_SIGN Signed Number(4,0) DECIMAL(3) NOT NULL Base Sign
27 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
28 GPFR_UNIT_SIGN Signed Number(4,0) DECIMAL(3) NOT NULL Unit Sign
29 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
30 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
31 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
32 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
33 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
34 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
35 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
36 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
37 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
38 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
39 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
40 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
41 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
42 PIN_CUSTOM2 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM2
43 PIN_CUSTOM3 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM3 fields
44 PIN_CUSTOM4 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM4
45 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5
46 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
47 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
48 PYMT_DT Date(10) DATE Payment Date
49 GP_ELN_ATTR6 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
50 GP_ELN_ATTR7 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
51 GP_ELN_ATTR8 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
52 GP_ELN_ATTR9 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
53 GP_ELN_ATTR10 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
54 GP_RPT_RETRO Character(1) VARCHAR2(1) NOT NULL Retroactivity Type
1=Original
2=Recalculation
3=Prior Calculation
4=Last Version/Revision
55 GP_RPT_SEG_NUM Number(4,0) SMALLINT NOT NULL Field used in report generation from GP