PA_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 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
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 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: PA_FNC_RSLT_DFN.EFFDT |
5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
6 | STOP_DATE | Date(10) | DATE | Stop Date |
7 | DEFINITION_NAME | Character(10) | VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
Prompt Table: %DFN_NAME_EDIT |
8 | GROUP_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Group Name
Prompt Table: PA_CUSTOM |
9 | START_DT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Start Date Type
A=Alias D=Date |
10 | START_DATE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Start Date Alias
Prompt Table: PA_DATE_ALS_VW |
11 | START_DATE_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Start Date Alias Type |
12 | STOP_DT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Stop Date Type
A=Alias Name D=Date Constant |
13 | STOP_DATE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Stop Date Alias
Prompt Table: PA_DATE_ALS_VW |
14 | STOP_DATE_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Stop Date Alias Type |
15 | BREAK_DFN_USE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Break Definition Use Code
1=Rehire 2=Termination |
16 | GROUP_PRECEDENCE | Number(2,0) | SMALLINT NOT NULL | Group Precedence Number |
17 | BREAK_DFN_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Break Definition Name
Prompt Table: PA_DFN_BREAK |
18 | ELIG_SCOPE | Character(1) | VARCHAR2(1) NOT NULL |
Scope of Plan Eligibility
B=Both N=Ineligible Y=Eligible Default Value: B |
19 | USE_ELG_OR_ALL_JBS | Character(1) | VARCHAR2(1) NOT NULL |
Use Eligible Or All Jobs
A=Use All Jobs E=Use Eligible Jobs Only |
20 | PA_STATUS_DATE | Date(10) | DATE | Pension Status Date |