PA_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 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