PA_DFN_SVC_STVW

(SQL View)
 Index Back

Service use of Action/Reason


SELECT DEFINITION_NAME ,SVC_DFN_TYPE ,CATEGORY ,RECORD_IMPACTED ,ADJUSTMENT_RULE ,PERIODS_ADD_TYPE ,PERIODS_TO_ADD ,PRDS_TO_ADD_ALS_NM ,PRDS_TO_AD_ALS_TYP ,PERIOD_UNIT ,DT_RND_OPT_NM ,MIN_MAX_INDICATOR ,MIN_MAX_HOURS ,LIMIT_PERIOD_HOURS ,ALLOCATION_PERIOD ,LIMITATION_PERIOD ,MIN_MAX_SERVICE ,ADD_TIME ,MIN_MAX_HRS_ADJ ,FUTURE_ADJ_FLAG ,HIRE_CATG_CD ,CATG_TYPE ,INCLUDE_CD FROM PS_PA_DFN_SVC_STAT

# 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

Default Value: S

3 CATEGORY Character(10) VARCHAR2(10) NOT NULL Category Name

Prompt Table: PA_HR_ACT

4 RECORD_IMPACTED Character(1) VARCHAR2(1) NOT NULL Record Impacted
A=All
F=First Only
L=Last Only
N=No Records Impacted
X=All But First
Y=All But Last
Z=All But First and Last

Default Value: N

5 ADJUSTMENT_RULE Character(1) VARCHAR2(1) NOT NULL Adjustment Rule
P=Periods to Add
U=User Code
6 PERIODS_ADD_TYPE Character(1) VARCHAR2(1) NOT NULL Periods to Add Field Type
N=Numeric Constant
V=Variable by employee
7 PERIODS_TO_ADD Number(3,0) SMALLINT NOT NULL Periods to Add
8 PRDS_TO_ADD_ALS_NM Character(10) VARCHAR2(10) NOT NULL Periods to add alias name

Prompt Table: PA_ALIAS_USE

9 PRDS_TO_AD_ALS_TYP Character(2) VARCHAR2(2) NOT NULL Periods to add alias type
10 PERIOD_UNIT Character(1) VARCHAR2(1) NOT NULL Unit of the Period
D=Days
M=Months
W=Weeks
Y=Years
11 DT_RND_OPT_NM Character(10) VARCHAR2(10) NOT NULL Date Round Option Name

Prompt Table: PA_DATE_RND_OPT

12 MIN_MAX_INDICATOR Character(1) VARCHAR2(1) NOT NULL Min/Max Indicator
M=Minimum
N=No Limit
X=Maximum

Default Value: N

13 MIN_MAX_HOURS Number(4,0) SMALLINT NOT NULL Min/Max Hours
14 LIMIT_PERIOD_HOURS Character(1) VARCHAR2(1) NOT NULL Limitation Period
C=Computation Period
S=Status Period
15 ALLOCATION_PERIOD Character(1) VARCHAR2(1) NOT NULL Allocation Period
C=Cut Off at Limit
D=Spread Across Days
16 LIMITATION_PERIOD Character(1) VARCHAR2(1) NOT NULL Limitation Period
S=Status Period
U=User Code

Default Value: S

17 MIN_MAX_SERVICE Number(10,6) DECIMAL(9,6) NOT NULL Minimum or Maximum Svc Amount
18 ADD_TIME Character(1) VARCHAR2(1) NOT NULL Add Time To Date?

Y/N Table Edit

19 MIN_MAX_HRS_ADJ Character(1) VARCHAR2(1) NOT NULL Min/Max Hours Adjust?

Y/N Table Edit

20 FUTURE_ADJ_FLAG Character(1) VARCHAR2(1) NOT NULL Future Adjustment Flag
A=Add Time to Current Act/Rsn
C=Ignore Current Action/Reason
F=Ignore Future Action/Reason
I=Insert Action/Reason
21 HIRE_CATG_CD Character(1) VARCHAR2(1) NOT NULL Hire/Rehire Category Indicator

Y/N Table Edit

Default Value: N

22 CATG_TYPE Character(1) VARCHAR2(1) NOT NULL Category Type
H=Hire Category
O=Other
T=Termination Category
23 INCLUDE_CD Character(1) VARCHAR2(1) NOT NULL Service Include Code

Y/N Table Edit