PA_FNC_RSLT_TBL(SQL Table) |
Index Back |
|---|---|
Function Result AliasThis 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
Prompt Table: PA_BEN_PLAN_VW |
| 2 | FUNCTN_NAME |
Character(10) | VARCHAR2(10) NOT NULL |
Function Name
Prompt Table: PA_FUNCTN |
| 3 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | USE_STARTUP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Use Start-Up
Y/N Table Edit Default Value: N |
| 6 | EACCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Account Type
1=Contribution Account 2=Withdrawal Account 3=Service Purchase |
| 7 | EACCT_FR_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Parent Contribution Account
Prompt Table: PA_DFN_EACCT_VW |
| 8 | SERVICE_FR_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Service Function Result Name
Prompt Table: PA_DFN_SVC_VW |
| 9 | SERVICE_ADJ_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Adjustment Method
1=Upon Full Payment/Redeposit 2=Upon Any Payment/Redeposit 3=On a Prorated Basis |
| 10 | PENSVC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Pen Svc Stat For Multi Job
Y/N Table Edit |