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 | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Function Name | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | Function Result Name | |
| 4 | Date(10) | DATE |
Effective Date
Default Value: PA_FNC_RSLT_DFN.EFFDT |
|
| 5 | Date(10) | DATE | Start Date for Gen Standing PO | |
| 6 | Date(10) | DATE | Stop Date | |
| 7 | Character(10) | VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
Prompt Table: %DFN_NAME_EDIT |
|
| 8 | 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 |