PA_SP_EACCT_FR(SQL View) |
Index Back |
|---|---|
Function Result AliasThis is a setup table containing Function Result Aliases. |
| SELECT BENEFIT_PLAN ,FUNCTN_RESULT_NM ,DESCR ,USE_STARTUP_IND ,EACCT_TYPE ,EACCT_FR_NAME ,SERVICE_ADJ_METHOD ,PENSVC_STAT FROM PS_PA_FNC_RSLT_TBL WHERE FUNCTN_NAME = 'EMPLACCTS' |
| # | 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_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | USE_STARTUP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Use Start-Up
Y/N Table Edit Default Value: N |
| 5 | EACCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Account Type
1=Contribution Account 2=Withdrawal Account 3=Service Purchase |
| 6 | EACCT_FR_NAME | Character(10) | VARCHAR2(10) NOT NULL |
This field represents a Contribution Employee Account Function Result.
Prompt Table: PA_DFN_EACCT_VW |
| 7 | 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 |
| 8 | PENSVC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Pen Svc Stat For Multi Job
Y/N Table Edit Default Value: N |