GPNL_SPC_AC1_VW(SQL View) |
Index Back |
---|---|
Prompt View- For Special PaysThis view selects Accumulators with Special Pays category. This view does not use the standard SBR because it uses an additional record in the select statement This view is called from PeopleCode using %GP_EDIT_FLD3. |
SELECT B.COUNTRY , B.PIN_NUM , B.PIN_NM , B.DESCR , B.COUNTRY FROM PS_GP_PIN B , PS_GP_ACCUMULATOR A WHERE A.PIN_NUM = B.PIN_NUM AND B.PIN_NUM < 50000000 AND B.PIN_TYPE = 'AC' AND B.COUNTRY = 'NLD' AND B.PIN_CATEGORY = 'SPEC' AND A.ACM_PRD_OPTN IN ('5') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
3 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL | Country Code |