PIN_NUMPIN_NMGPCH_ED_MAP_VW(SQL View) |
Index Back |
|---|---|
Earnings mapped to accountsEarnings mapped to accounts with Info on grouping. |
| SELECT GG.PIN_NUM , P.PIN_NM , P.DESCR ,' ' ,GM.GROUPING_CODE , CASE WHEN GM.REVERSE_SIGN = 'N' THEN 'Soll' ELSE 'Haben' END , GM.ACCOUNT , A.DESCR ,A.SETID ,GG.PAY_ENTITY FROM PS_GP_GL_GROUP_DTL GG , PS_GP_GL_MAP_DTL GM , PS_GP_PIN P , PS_GL_ACCOUNT_TBL A , PS_BUS_UNIT_TBL_HR BU WHERE GG.PAY_ENTITY = GM.PAY_ENTITY AND GG.BUSINESS_UNIT = GM.BUSINESS_UNIT AND GG.GROUPING_CODE = GM.GROUPING_CODE AND GG.PIN_NUM = P.PIN_NUM AND GM.ACCOUNT = A.ACCOUNT AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GL_ACCOUNT_TBL A1 WHERE A.SETID = A1.SETID AND A.ACCOUNT = A1.ACCOUNT AND A.EFF_STATUS = A1.EFF_STATUS ) AND GG.BUSINESS_UNIT = BU.BUSINESS_UNIT AND BU.DEFAULT_SETID = A.SETID |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 5 | GROUPING_CODE | Character(15) | VARCHAR2(15) NOT NULL | Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes. |
| 6 | DESCR10 | Character(10) | VARCHAR2(10) NOT NULL | Description field of length 10 |
| 7 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 8 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 10 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |