BENEFIT_PLANFUNCTN_NAMEFUNCTN_RESULT_NMEFFDTSTART_DATESTOP_DATEDEFINITION_NAMEGROUP_NAMEPA_GRP_PRECD_VW(SQL View) |
Index Back |
|---|---|
Group Precedence View |
| select benefit_plan, functn_name, functn_result_nm, effdt, start_date, stop_date,definition_name, group_name, group_precedence from PS_PA_FUNCTN_RESLT |
| # | 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 | Start Date for Gen Standing PO |
| 6 | STOP_DATE |
Date(10) | DATE | Stop Date |
| 7 | DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 8 | GROUP_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Group Name |
| 9 | GROUP_PRECEDENCE | Number(2,0) | SMALLINT NOT NULL | Group Precedence Number |