PA_FNC_RSLT_DFN (SQL Table)	Index Back
Function Result Alias This is a setup table containing Function Result Aliases.

PA_FNC_RSLT_DFN

(SQL Table)

Function Result Alias

This is a setup table containing Function Result Aliases.

# 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 NOT NULL Effective Date
Default Value: %date

5 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
A=Active
I=Inactive
Y/N Table Edit
Default Value: N

6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	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 NOT NULL	Effective Date Default Value: %date
5	ACTIVE_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Definition Active or Inactive? A=Active I=Inactive Y/N Table Edit Default Value: N
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).