GPIT_GP_PIN_VW(SQL View) |
Index Back |
---|---|
PIN Name ViewThis view is used primarily to display the PIN Name as a related field on the On-line panels. |
SELECT PIN_NUM ,PIN_NM FROM PS_GP_PIN WHERE PIN_NUM < 50000000 |
# | 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 |