EG_FUNCTN_RESLT(SQL Table) |
Index Back |
---|---|
Function Result TableThis 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 |