GPBR_NRP_NWH_VW

(SQL View)
 Index Back

Negative Deltas History Record

Writable Array used by Negative Deltas History Record

SELECT PSARCH_ID , PSARCH_BATCHNUM ,EMPLID ,EMPL_RCD ,CAL_RUN_ID ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,PIN_NUM + 50000000 ,SEQNBR ,RSLT_VER_NUM ,RSLT_REV_NUM ,GPBR_DATE1 ,GPBR_DATE2 ,GPBR_DATE3 ,GPBR_DATE4 ,GPBR_DATE5 ,GPBR_DATE6 ,USER_KEY1 ,USER_KEY2 ,USER_KEY3 ,USER_KEY4 ,USER_KEY5 ,USER_KEY6 ,KEY_SIGN_NUM_01 ,KEY_SIGN_NUM_02 ,KEY_SIGN_NUM_03 ,KEY_SIGN_NUM_04 ,KEY_SIGN_NUM_05 ,KEY_SIGN_NUM_06 ,CALC_RSLT_VAL ,USER_ADJ_VAL ,PIN_RTO_ADJ_NUM + 50000000 ,UNIT_RSLT_VAL ,UNIT_ADJ_VAL ,PCT_RSLT_VAL FROM PS_GPBR_NEG_WA_HST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
11 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
12 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
13 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
14 GPBR_DATE1 Date(10) DATE Date 1
15 GPBR_DATE2 Date(10) DATE Date Field used by Negative Delta Writable Array
16 GPBR_DATE3 Date(10) DATE Date Field used by Negative Delta Writable Array
17 GPBR_DATE4 Date(10) DATE Date Field used by Negative Delta Writable Array
18 GPBR_DATE5 Date(10) DATE Date Field used by Negative Delta Writable Array
19 GPBR_DATE6 Date(10) DATE Date Field used by Negative Delta Writable Array
20 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
21 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
22 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
23 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
24 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
25 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
26 KEY_SIGN_NUM_01 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
27 KEY_SIGN_NUM_02 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
28 KEY_SIGN_NUM_03 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
29 KEY_SIGN_NUM_04 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
30 KEY_SIGN_NUM_05 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
31 KEY_SIGN_NUM_06 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
32 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
33 USER_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL User Adjustment Value
34 PIN_RTO_ADJ_NUM Number(8,0) INTEGER NOT NULL Element number field
35 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
36 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
37 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value