GPCN_BDGT_PR_VW

(SQL View)
 Index Back

Payrol Result with Budget

View for the payroll result with DEPTID.

SELECT f.gpcn_bdgt_item , f.gpcn_bdgt_prd , f.setid , f.tree_name , f.tree_effdt , a.emplid , a.calc_val , d.cal_prd_id , a.slice_bgn_dt , a.slice_end_dt , c.company , b.chr_pin_val , a.pin_num FROM PS_GP_RSLT_ACUM a , ps_gp_rslt_pin b , ps_gp_seg_guide_wa c , ps_gp_calendar d , ps_gp_cal_prd e , ps_gpcn_bdgt_distr f , ps_gp_cal_run r WHERE a.cal_run_id = a.orig_cal_run_id AND a.emplid = b.emplid AND a.cal_run_id = b.cal_run_id AND a.empl_rcd = b.empl_rcd AND a.gp_paygroup = b.gp_paygroup AND a.cal_id = b.cal_id AND a.rslt_seg_num = b.rslt_seg_num AND a.slice_bgn_dt = b.slice_bgn_dt AND a.slice_end_dt = b.slice_end_dt AND a.pin_num IN ( SELECT h.pin_num FROM ps_gpcn_bdgt_accu h WHERE f.gpcn_bdgt_item = h.gpcn_bdgt_item) AND b.pin_num = ( SELECT pin_num FROM ps_gp_pin WHERE pin_code = 'CN FM DEPTID CHN') AND a.emplid = c.emplid AND a.cal_run_id = c.cal_run_id AND a.empl_rcd = c.empl_rcd AND a.gp_paygroup = c.gp_paygroup AND a.cal_id = c.cal_id AND a.rslt_seg_num = c.rslt_seg_num AND a.gp_paygroup = d.gp_paygroup AND a.cal_id = d.cal_id AND d.cal_prd_id = e.cal_prd_id AND e.cal_prd_id IN ( SELECT g.cal_prd_id FROM ps_gpcn_bdgt_prdmp g WHERE f.gpcn_bdgt_prd = g.gpcn_bdgt_prd) AND a.cal_run_id = r.cal_run_id AND r.run_finalized_ind = 'Y' AND f.gpcn_bdgt_stats = 'D' UNION ALL SELECT f.gpcn_bdgt_item , f.gpcn_bdgt_prd , f.setid , f.tree_name , f.tree_effdt , a.emplid , a.calc_val , cal.cal_prd_id , a.slice_bgn_dt , a.slice_end_dt , c.company , b.chr_pin_val , a.pin_num FROM PS_GP_RSLT_ACUM a , ps_gp_rslt_pin b , ps_gp_seg_guide_wa c , ps_gpcn_bdgt_distr f , ps_gp_pye_cal cal , ps_gp_cal_run r WHERE a.cal_run_id = a.orig_cal_run_id AND a.emplid = b.emplid AND a.cal_run_id = b.cal_run_id AND a.empl_rcd = b.empl_rcd AND a.gp_paygroup = b.gp_paygroup AND a.cal_id = b.cal_id AND a.rslt_seg_num = b.rslt_seg_num AND a.slice_bgn_dt = b.slice_bgn_dt AND a.slice_end_dt = b.slice_end_dt AND a.pin_num IN ( SELECT h.pin_num FROM ps_gpcn_bdgt_accu h WHERE f.gpcn_bdgt_item = h.gpcn_bdgt_item) AND b.pin_num = ( SELECT pin_num FROM ps_gp_pin WHERE pin_code = 'CN FM DEPTID CHN') AND a.emplid = c.emplid AND a.cal_run_id = c.cal_run_id AND a.empl_rcd = c.empl_rcd AND a.cal_id = cal.cal_id AND a.gp_paygroup = cal.gp_paygroup AND a.emplid = cal.emplid AND a.empl_rcd = cal.empl_rcd AND cal.cal_prd_id IN ( SELECT g.cal_prd_id FROM ps_gpcn_bdgt_prdmp g WHERE f.gpcn_bdgt_prd = g.gpcn_bdgt_prd) AND a.cal_run_id = r.cal_run_id AND r.run_finalized_ind = 'Y' AND f.gpcn_bdgt_stats = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPCN_BDGT_ITEM Character(10) VARCHAR2(10) NOT NULL Budget Item

Prompt Table: GPCN_BDGT_ITEM

2 GPCN_BDGT_PRD Character(10) VARCHAR2(10) NOT NULL Budget Period

Prompt Table: GPCN_BDGT_PRD

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: GPCN_SEC_T_VW

5 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

Prompt Table: GPCN_SEC_TE_VW

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value
8 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
9 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
10 SLICE_END_DT Date(10) DATE Element Slice End Date
11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
12 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
13 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number