EG_SVC_ELT_SRCH

(SQL View)
 Index Back

Svc Parms View - Elapsed Time

Svc Parms View - Elapsed Time

SELECT DEFINITION_NAME ,SVC_DFN_TYPE ,EG_SERVICE_TYPE ,DESCR ,CALENDAR_ID ,EG_PERIOD_TYPE ,EG_PRORATE_MTHD ,FTE_EQUIV ,DT_RND_ORD_NUM ,ADD_TIME_ORD_NUM ,FUT_ADJ_ORD_NUM ,DATE_OPTION ,PRORATE_PREV_TYPE ,PRORATE_PREV_UNIT ,PRORATE_CUR_TYPE ,PRORATE_CUR_UNIT ,ELAPSED_TIME_TYPE ,ELAP_TIME_DU_OPT ,EG_FNL_SVC_RSLT_UN ,FNL_RSLT_DU_OPT ,FNL_ADD_SVC_TYP ,EG_FNL_ADD_SVC_NUM ,FNL_ADD_SVC_ALS_NM ,FNL_ADD_SVC_ALS_TY ,FNL_SUB_SVC_TYP ,EG_FNL_SUB_SVC_NUM ,FNL_SUB_SVC_ALS_NM ,FNL_SUB_SVC_ALS_TY ,FNL_MIN_SVC_TYP ,EG_FNL_MIN_SVC_NUM ,FNL_MIN_SVC_ALS_NM ,FNL_MIN_SVC_ALS_TY ,FNL_MAX_SVC_TYP ,EG_FNL_MAX_SVC_NUM ,FNL_MAX_SVC_ALS_NM ,FNL_MAX_SVC_ALS_TY ,BRK_RQRMT_NUM ,BRK_WAIT_ELAP_CD ,BRK_WAIT_ASS_DAY ,BRK_ELAP_PRD_CD ,BRK_ELAP_UNIT_CD ,BRK_ELP_DU_OPT ,EG_DT_RND_OPT_NAME FROM PS_EG_DFN_SVC WHERE EG_SERVICE_TYPE = 'E'

# 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 EG_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL Service Type
E=Elapsed Time
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
6 EG_PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Computational Period
M=Month
Q=Quarter
S=Semester
T=Term
Y=Computational Year
7 EG_PRORATE_MTHD Character(1) VARCHAR2(1) NOT NULL Prorate By
F=FTE
N=None
8 FTE_EQUIV Number(4,2) DECIMAL(3,2) NOT NULL Pro-rate if below
9 DT_RND_ORD_NUM Number(1,0) SMALLINT NOT NULL Date round order number
10 ADD_TIME_ORD_NUM Number(1,0) SMALLINT NOT NULL Add time order number
11 FUT_ADJ_ORD_NUM Number(1,0) SMALLINT NOT NULL Future adjustment order number
12 DATE_OPTION Character(10) VARCHAR2(10) NOT NULL Duration Option
13 PRORATE_PREV_TYPE Character(1) VARCHAR2(1) NOT NULL Data to be Prorated
H=Hours
S=Service
U=User Code

Default Value: S

14 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

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

Default Value: S

16 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

17 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
18 ELAP_TIME_DU_OPT Character(10) VARCHAR2(10) NOT NULL Elapsed Time Duration Option

Prompt Table: PA_DURATION_OPT

19 EG_FNL_SVC_RSLT_UN Character(1) VARCHAR2(1) NOT NULL Final Service Result Unit Code
Y=Years
20 FNL_RSLT_DU_OPT Character(10) VARCHAR2(10) NOT NULL Final Rslt Dec Cnvrsn Opt

Prompt Table: PA_DURATION_OPT

21 FNL_ADD_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Add Service Type
22 EG_FNL_ADD_SVC_NUM Number(6,2) DECIMAL(5,2) NOT NULL Final Add Service Amount
23 FNL_ADD_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL ADD SVC ALIAS NAME

Prompt Table: PA_ALIAS_USE

24 FNL_ADD_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL ADD SVC ALIAS TYPE
25 FNL_SUB_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Subtract Service Type
26 EG_FNL_SUB_SVC_NUM Number(6,2) DECIMAL(5,2) NOT NULL Final Sub Service Amount
27 FNL_SUB_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL SVC SUBTRACT ALIAS NAME

Prompt Table: PA_ALIAS_USE

28 FNL_SUB_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL SVC SUB ALIAS TYPE
29 FNL_MIN_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Minimum Service Type
30 EG_FNL_MIN_SVC_NUM Number(6,2) DECIMAL(5,2) NOT NULL Final Minimum Service Amount
31 FNL_MIN_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL MIN SVC ALIAS NAME

Prompt Table: PA_ALIAS_USE

32 FNL_MIN_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL MIN SVC ALIAS TYPE
33 FNL_MAX_SVC_TYP Character(1) VARCHAR2(1) NOT NULL Final Maximum Service Type
34 EG_FNL_MAX_SVC_NUM Number(6,2) DECIMAL(5,2) NOT NULL Final Maximum Service Amount
35 FNL_MAX_SVC_ALS_NM Character(10) VARCHAR2(10) NOT NULL FINAL MAX SERVICE AMT ALIAS NM

Prompt Table: PA_ALIAS_USE

36 FNL_MAX_SVC_ALS_TY Character(2) VARCHAR2(2) NOT NULL FINAL MAX SVC ALIAS TYPE
37 BRK_RQRMT_NUM Number(3,0) SMALLINT NOT NULL # Breaks Needed to Lose Svc
38 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

39 BRK_WAIT_ASS_DAY Number(3,0) SMALLINT NOT NULL # days/yr
40 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

41 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

42 BRK_ELP_DU_OPT Character(10) VARCHAR2(10) NOT NULL Break Id for Elapsed Time
43 EG_DT_RND_OPT_NAME Character(10) VARCHAR2(10) NOT NULL Date Rounding Option Name