FPY_POS_VW(SQL View) |
Index Back |
|---|---|
Position ViewPosition view |
| SELECT PROCESS_INSTANCE , POSITION_NBR , FPY_POSITION_ID , FPY_MODE FROM PS_FPY_POS_STG_TBL WHERE FPY_BYPASS_FLG <>'Y' AND FPY_PROCESSED_FLG <> 'Y' GROUP BY PROCESS_INSTANCE, FPY_POSITION_ID, POSITION_NBR , FPY_MODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 3 | FPY_POSITION_ID | Number(18,0) | DECIMAL(18) NOT NULL | Position ID |
| 4 | FPY_MODE | Character(1) | VARCHAR2(1) NOT NULL | FPY_MODE |