PIN_NUM1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period
GPAU_STP_LE_VW(SQL View) |
Index Back |
|---|---|
STP LE ViewSTP SOVR Category LE view |
| SELECT DISTINCT GP.PIN_NUM , GP.PIN_NM , SOVR.SOVR_VAL_CHAR , SOVR.PIN_SOVR_NUM , MBR.PIN_MBR_NUM , SOVR.BGN_DT , SOVR.END_DT , MBR.BGN_DT , MBR.END_DT , AC.ACM_PRD_OPTN FROM PS_GP_ACM_MBR MBR ,PS_GP_ACCUMULATOR AC ,PS_GP_PIN GP ,PS_GP_ELM_DFN_SOVR SOVR WHERE AC.ACM_PRD_OPTN = '2' AND GP.PIN_NM LIKE '%_FPTDA%' AND AC.PIN_NUM = MBR.PIN_NUM AND GP.PIN_NUM = MBR.PIN_NUM AND MBR.PIN_MBR_NUM = SOVR.PIN_NUM AND GP.PIN_NUM < 50000000 AND SOVR.SOVR_VAL_CHAR = 'LE' AND SOVR.PIN_SOVR_NUM = ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_CODE = 'EOY VR CATEGORY AUS') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 3 | SOVR_VAL_CHAR | Character(25) | VARCHAR2(25) NOT NULL | Supporting Element Character Value |
| 4 | PIN_SOVR_NUM | Number(8,0) | INTEGER NOT NULL | Supporting Element PIN Number |
| 5 | PIN_MBR_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 6 | BGN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 9 | END_DATE | Date(10) | DATE | End Date |
| 10 | ACM_PRD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Period
1=Segment 2=Calendar Period 3=Month to Date 4=Quarter to Date 5=Year to Date 6=Custom Period |