LI_IMPORT_IDPrompt Table: RB_IMPT_ACT_VW
RB_IMP_EDIT_V2(SQL View) |
Index Back |
|---|---|
Import Definition ViewSearch View for import definition |
| SELECT B.LI_IMPORT_ID , B.LI_SCHED_GEN_DATE , MAX(B.LI_SCHED_GEN_TIME) FROM PS_RB_IMPORT_DEFN A , PS_RB_IMPT_RUNSPEC B , PS_RB_DIST_MATCH_V E WHERE A.LI_IMPORT_ID = B.LI_IMPORT_ID AND B.RUN_CNTL_ID = E.RUN_CNTL_ID AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_RB_IMPORT_DEFN X WHERE X.LI_IMPORT_ID = A.LI_IMPORT_ID AND X.EFFDT <= %CurrentDateIn) GROUP BY B.LI_IMPORT_ID, B.LI_SCHED_GEN_DATE |
| # | 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 |