RB_IMP_EDIT_V3(SQL View) |
Index Back |
---|---|
Import Definition ViewSearch View for import definition |
SELECT B.LI_IMPORT_ID , MAX(B.LI_SCHED_GEN_DATE) , MAX(B.LI_SCHED_GEN_TIME) FROM PS_RB_IMP_EDIT_V2 B GROUP BY B.LI_IMPORT_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LI_IMPORT_ID | Character(31) | VARCHAR2(31) NOT NULL |
Import ID
Prompt Table: RB_IMPT_ACT_VW |
2 | LI_SCHED_GEN_DATE | Date(10) | DATE | Scheduled Generation Date |
3 | LI_SCHED_GEN_TIME | Time(15) | TIMESTAMP | Scheduled Generation Time |