GPUS_NRP_BAE_VW

(SQL View)
 Index Back

Benefit Deduction Accumulators

Element map definition view for table GPUS_BENACM_EXT

SELECT PROCESS_INSTANCE , EMPLID , EMPL_RCD , GP_PAYGROUP , CAL_RUN_ID , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , GP_RPT_KEY , SEQ_NUM , COMPANY , PIN_NUM + 50000000 , PIN_PARENT_NUM + 50000000 , ACM_FROM_DT , ACM_THRU_DT , SLICE_BGN_DT , SLICE_END_DT , ACM_PRD_OPTN , CALC_RSLT_VAL , BENEFIT_PROGRAM , PLAN_TYPE , BENEFIT_PLAN , EFFDT , DEDCD FROM PS_GPUS_BENACM_EXT

# 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 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_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
12 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
13 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number
14 ACM_FROM_DT Date(10) DATE From Date
15 ACM_THRU_DT Date(10) DATE Through Date
16 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
17 SLICE_END_DT Date(10) DATE Element Slice End Date
18 ACM_PRD_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Period
1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period
19 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
20 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
21 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
22 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
23 EFFDT Date(10) DATE Effective Date
24 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code