ASOFDATEPIN_NMGP_PINTREE_VW(SQL View) |
Index Back |
|---|---|
Element Map View 1.This view selects off the Element Pin Map table to form the 'Uses' relationship. |
| SELECT A.EFFDT , B.PIN_NM , A.PIN_NUM , C.PIN_NM , A.PIN_MBR_NUM , A.FLDMAP_RECNUM_KEY , A.FLDMAP_FLDNUM_KEY1 , A.FLDMAP_FLDNUM_KEY2 FROM PS_GP_PINMAP_EFFDT A , PS_GP_PIN B , PS_GP_PIN C WHERE A.PIN_NUM = B.PIN_NUM AND A.PIN_MBR_NUM = C.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASOFDATE |
Date(10) | DATE | As of Date |
| 2 | PIN_NM |
Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 3 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 4 | PIN_MBR_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 5 | PIN_MBR_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 6 | FLDMAP_RECNUM_KEY | Number(9,0) | DECIMAL(9) NOT NULL | Record # identifier Key |
| 7 | FLDMAP_FLDNUM_KEY1 | Number(9,0) | DECIMAL(9) NOT NULL | Field Number Key Identifier 1 |
| 8 | FLDMAP_FLDNUM_KEY2 | Number(9,0) | DECIMAL(9) NOT NULL | Field Number Key Identifier 2 |