EG_FNC_RSLT_DFN

(SQL Table)
Index Back

Function Result Alias

This is a setup table containing Function Result Aliases.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group
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 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
A=Active
I=Inactive

Default Value: A

5 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
6 CALC_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL Calc Seq Num
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).