EG_GROUPFUNCTN_RESULT_NMEG_GRP_CAL_VW(SQL View) |
Index Back |
|---|---|
Flexible Service Type VwThis is a setup view for Flexible Service Type (i.e. Function Result Name). |
| SELECT A.EG_GROUP ,A.FUNCTN_RESULT_NM ,C.BEGIN_DT ,C.END_DT ,A.DEFINITION_NAME ,B.CALENDAR_ID ,C.FISCAL_YEAR ,C.EG_PERIOD ,C.EG_PRD_COUNT FROM PS_EG_FUNCTN_RESLT A, PS_EG_DFN_SVC B, PS_EG_CAL_DETP_TBL C WHERE A.DEFINITION_NAME = B.DEFINITION_NAME AND B.SVC_DFN_TYPE = 'S' AND B.CALENDAR_ID = C.CALENDAR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EG_GROUP |
Character(6) | VARCHAR2(6) NOT NULL | Service Calculation Group |
| 2 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 3 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 4 | END_DT | Date(10) | DATE | end date |
| 5 | DEFINITION_NAME | Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 6 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 7 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 8 | EG_PERIOD | Number(3,0) | SMALLINT NOT NULL | Tenure Period |
| 9 | EG_PRD_COUNT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | # of Periods count for Tenure |