PA_SVC_HRC_SRCH

(SQL View)
 Index Back

Svc Parms View - Hours Count


SELECT DEFINITION_NAME ,SVC_DFN_TYPE ,DESCR ,EXCL_SVC_CD ,EXCLUDE_PRIOR_TYPE ,EXCL_SVC_B4_DT ,EXCL_SVC_B4_ALS ,XCL_SVC_B4_ALS_TYP ,EXCLUDE_AFTER_TYPE ,EXCL_SVC_AFT_DT ,EXCL_SVC_AFT_ALS ,X_SVC_AFT_ALS_TYP ,SERVICE_TYPE ,COMPUTATION_PERIOD ,INIT_COMP_ANNIVYR ,HRS_CONSOLIDATION ,CONTRIB_CODE ,CONTRIB_NAME ,DT_RND_ORD_NUM ,ADD_TIME_ORD_NUM ,FUT_ADJ_ORD_NUM ,CUR_FUT_PROJ_MTHD ,EQUIV_TYPE ,HRS_TIM_TYP ,HRS_RQRMT_AMT ,TIME_RQRMT_AMT ,CONSEC_TIME_TYP ,DOL_STANDARD ,EQUIV_PERIOD_CD ,EQUIV_PERIOD ,DATE_OPTION ,PRORATE_PREV_TYPE ,PRORATE_PREV_UNIT ,PRORATE_CUR_TYPE ,PRORATE_CUR_UNIT ,ELAPSED_TIME_TYPE ,ELAP_TIME_DU_OPT ,FNL_SVC_RSLT_UNIT ,FNL_RSLT_DU_OPT ,FNL_ADD_SVC_TYP ,FNL_ADD_SVC_NUM ,FNL_ADD_SVC_ALS_NM ,FNL_ADD_SVC_ALS_TY ,FNL_SUB_SVC_TYP ,FNL_SUB_SVC_NUM ,FNL_SUB_SVC_ALS_NM ,FNL_SUB_SVC_ALS_TY ,FNL_MIN_SVC_TYP ,FNL_MIN_SVC_NUM ,FNL_MIN_SVC_ALS_NM ,FNL_MIN_SVC_ALS_TY ,FNL_MAX_SVC_TYP ,FNL_MAX_SVC_NUM ,FNL_MAX_SVC_ALS_NM ,FNL_MAX_SVC_ALS_TY ,BRK_1YR_WAIT_YN ,BRK_SVC_RSTR_CD ,BRK_1YR_WAIT_TYPE ,BRK_1YR_TYPE ,BRK_1YR_HRS_NUM ,BRK_RQRMT_NUM ,BRK_PRI_SVC_MIN_YN ,BRK_RSTR_VSTD_YN ,BRK_WAIT_ELAP_CD ,BRK_WAIT_ASS_DAY ,BRK_ELAP_PRD_CD ,BRK_ELAP_UNIT_CD FROM PS_PA_DFN_SVC WHERE SERVICE_TYPE = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEFINITION_NAME Character(10) VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL
2 SVC_DFN_TYPE Character(1) VARCHAR2(1) NOT NULL For future use
B=Break Definition
S=Service Definition Type
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 EXCL_SVC_CD Character(1) VARCHAR2(1) NOT NULL Service Exclusion Indicator
5 EXCLUDE_PRIOR_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type for Exclude Prior
D=Date Constant
V=Vary by Employee
6 EXCL_SVC_B4_DT Date(10) DATE Exclude service before date
7 EXCL_SVC_B4_ALS Character(10) VARCHAR2(10) NOT NULL Exclude service b4 alias date

Prompt Table: PA_ALIAS_USE

8 XCL_SVC_B4_ALS_TYP Character(2) VARCHAR2(2) NOT NULL Exclude service b4 alias type
9 EXCLUDE_AFTER_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type for Exclude After
D=Date Constant
V=Vary by Employee
10 EXCL_SVC_AFT_DT Date(10) DATE Exclude service after date
11 EXCL_SVC_AFT_ALS Character(10) VARCHAR2(10) NOT NULL Exclude service after alias dt

Prompt Table: PA_ALIAS_USE

12 X_SVC_AFT_ALS_TYP Character(2) VARCHAR2(2) NOT NULL Exclude svc after alias dt typ
13 SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL Sevice type
1=Service Request
2=Service Reply
C=Hours Counting
E=Elapsed Time
H=Hours Equivalence
T=Hours and Time Dependent
14 COMPUTATION_PERIOD Character(1) VARCHAR2(1) NOT NULL Computation Period
A=Anniversary Year
M=Calendar Month
P=Plan Year
Y=Calendar Year

Default Value: Y

15 INIT_COMP_ANNIVYR Character(1) VARCHAR2(1) NOT NULL First Period is Anniv Year

Y/N Table Edit

Default Value: N

16 HRS_CONSOLIDATION Character(10) VARCHAR2(10) NOT NULL Hours Consolidation Name

Prompt Table: PA_CONS_HRS

17 CONTRIB_CODE Character(1) VARCHAR2(1) NOT NULL 05/22/03 Lee - ICE 51596000 Correct spelling of Service

Y/N Table Edit

Default Value: N

18 CONTRIB_NAME Character(10) VARCHAR2(10) NOT NULL Contrib History Name

Prompt Table: PA_CONS_DED

19 DT_RND_ORD_NUM Number(1,0) SMALLINT NOT NULL Date round order number
20 ADD_TIME_ORD_NUM Number(1,0) SMALLINT NOT NULL Add time order number
21 FUT_ADJ_ORD_NUM Number(1,0) SMALLINT NOT NULL Future adjustment order number
22 CUR_FUT_PROJ_MTHD Character(10) VARCHAR2(10) NOT NULL Current/Future Projection Mthd

Prompt Table: PA_PROJECTIONS

23 EQUIV_TYPE Character(1) VARCHAR2(1) NOT NULL Hours Equivalence Type
C=Custom
D=DOL Standard
U=User Code

Default Value: D

24 HRS_TIM_TYP Character(1) VARCHAR2(1) NOT NULL Hours && Time Type
H=Hours/Time - Hours Dependent
N=Hours/Time - No dependencies
T=Hours/Time - Time Dependent
25 HRS_RQRMT_AMT Number(4,0) SMALLINT NOT NULL Hrs/Time - Hrs Requirement Amt
26 TIME_RQRMT_AMT Number(3,0) SMALLINT NOT NULL Hrs/Time- Time Requirement Amt
27 CONSEC_TIME_TYP Character(1) VARCHAR2(1) NOT NULL Consecutive Time- Months/Years
M=Consecutive Months
Y=Consecutive Years
28 DOL_STANDARD Character(1) VARCHAR2(1) NOT NULL DOL Standard Rules
F=45 Hours / Week
N=95 Hours / Semi-Month
O=190 Hours / Month
T=10 Hours / Day

Default Value: T

29 EQUIV_PERIOD_CD Character(1) VARCHAR2(1) NOT NULL Customized Equivalence Rules
D=Day
M=Month
S=Semi-Month
U=User Code
W=Week

Default Value: D

30 EQUIV_PERIOD Number(5,0) INTEGER NOT NULL Custom Hours
31 DATE_OPTION Character(10) VARCHAR2(10) NOT NULL Duration Option
32 PRORATE_PREV_TYPE Character(1) VARCHAR2(1) NOT NULL Data to be Prorated
H=Hours
S=Service
U=User Code

Default Value: S

33 PRORATE_PREV_UNIT Character(1) VARCHAR2(1) NOT NULL Counting Units for Proration
D=Days
E=Equivalent Periods
M=Months
U=User Code
W=Weeks

Default Value: D

34 PRORATE_CUR_TYPE Character(1) VARCHAR2(1) NOT NULL Data to be Prorated
H=Hours
S=Service
U=User Code

Default Value: S

35 PRORATE_CUR_UNIT Character(1) VARCHAR2(1) NOT NULL Counting Units for Proration
D=Days
E=Equivalent Periods
M=Months
U=User Code
W=Weeks

Default Value: D

36 ELAPSED_TIME_TYPE Character(1) VARCHAR2(1) NOT NULL Time of Elapsed Time Service
D=Decimal Date Subtraction
P=Count Periods
R=Raw Date Subtraction
37 ELAP_TIME_DU_OPT Character(10) VARCHAR2(10) NOT NULL Elapsed Time Duration Option

Prompt Table: PA_DURATION_OPT

38 FNL_SVC_RSLT_UNIT Character(1) VARCHAR2(1) NOT NULL Final Service Result Unit Code
M=Months
Y=Years
39 FNL_RSLT_DU_OPT Character(10) VARCHAR2(10) NOT NULL Final Rslt Dec Cnvrsn Opt

Prompt Table: PA_DURATION_OPT

40 FNL_ADD_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Add Service Type
41 FNL_ADD_SVC_NUM Number(3,0) SMALLINT NOT NULL Final Add Service Amount
42 FNL_ADD_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL ADD SVC ALIAS NAME

Prompt Table: PA_ALIAS_USE

43 FNL_ADD_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL ADD SVC ALIAS TYPE
44 FNL_SUB_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Subtract Service Type
45 FNL_SUB_SVC_NUM Number(3,0) SMALLINT NOT NULL Final Subtract Service Amount
46 FNL_SUB_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL SVC SUBTRACT ALIAS NAME

Prompt Table: PA_ALIAS_USE

47 FNL_SUB_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL SVC SUB ALIAS TYPE
48 FNL_MIN_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Minimum Service Type
49 FNL_MIN_SVC_NUM Number(3,0) SMALLINT NOT NULL Final Minimum Service Amount
50 FNL_MIN_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL MIN SVC ALIAS NAME

Prompt Table: PA_ALIAS_USE

51 FNL_MIN_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL MIN SVC ALIAS TYPE
52 FNL_MAX_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Maximum Service Type
53 FNL_MAX_SVC_NUM Number(3,0) SMALLINT NOT NULL Final Maximum Service Amount
54 FNL_MAX_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL MAX SERVICE AMT ALIAS NM

Prompt Table: PA_ALIAS_USE

55 FNL_MAX_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL MAX SVC ALIAS TYPE
56 BRK_1YR_WAIT_YN Character(1) VARCHAR2(1) NOT NULL One year wait code (y/n)

Y/N Table Edit

Default Value: N

57 BRK_SVC_RSTR_CD Character(1) VARCHAR2(1) NOT NULL Service restoration rule code
C=Count Breaks
L=Always Lose Service
R=Always Restore Service
U=User Code

Default Value: C

58 BRK_1YR_WAIT_TYPE Character(1) VARCHAR2(1) NOT NULL One year wait type
E=Elapsed Time
U=User Code

Default Value: E

59 BRK_1YR_TYPE Character(1) VARCHAR2(1) NOT NULL One year break type
E=Elapsed Time
H=Hours Threshold
U=User Code

Default Value: E

60 BRK_1YR_HRS_NUM Number(4,0) SMALLINT NOT NULL 1 yr break hours threshold
61 BRK_RQRMT_NUM Number(3,0) SMALLINT NOT NULL # Breaks Needed to Lose Svc
62 BRK_PRI_SVC_MIN_YN Character(1) VARCHAR2(1) NOT NULL Use Rule of Parity

Y/N Table Edit

Default Value: N

63 BRK_RSTR_VSTD_YN Character(1) VARCHAR2(1) NOT NULL Restore Service if Vested

Y/N Table Edit

Default Value: N

64 BRK_WAIT_ELAP_CD Character(1) VARCHAR2(1) NOT NULL Elapsed time wait unit code
D=Days per Year
M=Months
U=User Code

Default Value: M

65 BRK_WAIT_ASS_DAY Number(3,0) SMALLINT NOT NULL # days/yr
66 BRK_ELAP_PRD_CD Character(1) VARCHAR2(1) NOT NULL Elapsed time year
C=Calendar Year
H=Hire Anniversary Year
P=Plan Year
T=Term Anniversary Year

Default Value: H

67 BRK_ELAP_UNIT_CD Character(1) VARCHAR2(1) NOT NULL Elapsed time counting period
D=Days per Year
M=Months
U=User Code

Default Value: M