GPES_PSLIP_TMP4

(SQL Table)
Index Back

Pay Slip Temp Table

Pay Slip Temp Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
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 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
12 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
13 SLICE_END_DT Date(10) DATE Element Slice End Date
14 GPES_PAYSLIP_ID Character(6) VARCHAR2(6) NOT NULL Pay Slip Identification
15 GPES_ELEMENT_ORD Number(9,2) DECIMAL(8,2) NOT NULL Print Order of the element in payslip
16 EFFDT_USED Date(10) DATE Date driving 'processed' code
17 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
18 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
19 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
20 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
21 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
22 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
24 GPES_LINES_BEFORE Number(2,0) SMALLINT NOT NULL Number of lines before the element in payslip
25 GPES_LINES_AFTER Number(2,0) SMALLINT NOT NULL Number of lines after the element in payslip
26 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
27 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
28 SEL_ACTION Character(1) VARCHAR2(1) NOT NULL Select Action
A=Retro Add
C=Current Calculation
R=Retro Recalc
V=Retro Reversal
Z=Retro Rvr & Recalc
29 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name