PIN_NUMEFFDTSEQ_NUM5Prompt Table: GP_ENT_COND_VW
GP_PKG_PR2_VW(SQL View) |
Index Back |
|---|---|
Process DetailsGlobal Payroll Process Details view record. |
| SELECT PIN_NUM + 50000000 , EFFDT , SEQ_NUM5 , ENTRY_TYPE_COND , PIN_COND_NUM , PIN_SECT_NUM FROM PS_GP_PROCESS_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | ENTRY_TYPE_COND | Character(3) | VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table: GP_ENT_COND_VW |
| 5 | PIN_COND_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 6 | PIN_SECT_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |