EG_FUNCTN_RESLT

(SQL Table)
Index Back

Function Result Table

This is a setup table containing Funtion Results.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group

Prompt Table: EG_CALC_GRP_TBL

2 FUNCTN_NAME Character(10) VARCHAR2(10) NOT NULL Function Name
3 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
4 START_DATE Date(10) DATE Start Date for Gen Standing PO
5 STOP_DATE Date(10) DATE Stop Date
6 DEFINITION_NAME Character(10) VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL

Prompt Table: %DFN_NAME_EDIT

7 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %Date

8 START_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Start Date Type
A=Alias
D=Date
9 START_DATE_ALIAS Character(10) VARCHAR2(10) NOT NULL Start Date Alias

Prompt Table: EG_DATE_ALS_VW

10 START_DATE_ALIAST Character(2) VARCHAR2(2) NOT NULL Start Date Alias Type
11 STOP_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Stop Date Type
A=Alias Name
D=Date Constant
12 STOP_DATE_ALIAS Character(10) VARCHAR2(10) NOT NULL Stop Date Alias

Prompt Table: EG_DATE_ALS_VW

13 STOP_DATE_ALIAST Character(2) VARCHAR2(2) NOT NULL Stop Date Alias Type
14 BREAK_DFN_USE_CD Character(1) VARCHAR2(1) NOT NULL Break Definition Use Code
1=Rehire
2=Termination
15 GROUP_PRECEDENCE Number(2,0) SMALLINT NOT NULL Group Precedence Number
16 BREAK_DFN_NAME Character(10) VARCHAR2(10) NOT NULL Break Definition Name
17 ELIG_SCOPE Character(1) VARCHAR2(1) NOT NULL Scope of Plan Eligibility
B=Both
N=Ineligible
Y=Eligible

Default Value: B

18 EG_ELIG_CRITR Character(1) VARCHAR2(1) NOT NULL Eligibility Criteria
A=Full time, Regular
B=Full time, temporary
C=Full time/Parttime, Regular
D=Fulltime, part time, temporary
E=All