GP_NRP_RSPIN_VW

(SQL View)
Index Back

Results for "other" PIN - View

Result table for PINs other than ERN, DED and ACUM - Packaging View

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,INSTANCE ,PIN_NUM + 50000000 ,SLICE_BGN_DT ,SLICE_END_DT ,CALC_RSLT_VAL ,CHR_PIN_VAL ,DATE_PIN_VAL ,PIN_VAL_NUM + 50000000 FROM PS_GP_RSLT_PIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
10 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
11 SLICE_END_DT Date(10) DATE Element Slice End Date
12 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
13 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
14 DATE_PIN_VAL Date(10) DATE Calculation Date Result
15 PIN_VAL_NUM Number(8,0) INTEGER NOT NULL Calculation Element Number Result