PA_FRSLT_SUMMRY

(SQL View)
 Index Back

Function Result Summary View


select a.benefit_plan ,a.functn_name ,a.functn_result_nm ,a.effdt ,a.start_date ,a.start_date_alias ,a.stop_date_alias ,a.stop_date ,a.start_dt_type ,a.stop_dt_type ,a.definition_name ,a.group_name ,b.descr from PS_PA_FUNCTN_RESLT a, ps_pa_fnc_rslt_tbl b where a.benefit_plan=b.benefit_plan and a.functn_name=b.functn_name and a.functn_result_nm = b.functn_result_nm

# 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
5 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
6 START_DATE_ALIAS Character(10) VARCHAR2(10) NOT NULL Start Date Alias
7 STOP_DATE_ALIAS Character(10) VARCHAR2(10) NOT NULL Stop Date Alias
8 STOP_DATE Date(10) DATE NOT NULL Stop Date
9 START_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Start Date Type
A=Alias
D=Date
10 STOP_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Stop Date Type
A=Alias Name
D=Date Constant
11 DEFINITION_NAME Character(10) VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL

Prompt Table: %DFN_NAME_EDIT

12 GROUP_NAME Character(10) VARCHAR2(10) NOT NULL Group Name

Prompt Table: PA_CUSTOM

13 DESCR Character(30) VARCHAR2(30) NOT NULL Description