LI_IMPORT_IDPrompt Table: RB_IMPT_ACT_VW
DESCRRB_IMP_RUN_VW(SQL View) |
Index Back |
|---|---|
Import Definition ViewSearch View for import definition |
| SELECT DISTINCT A.LI_IMPORT_ID , A.DESCR ,C.DESCR , B.RUN_CNTL_ID ,C.LI_IMPORT_TYPE_ID FROM PS_RB_IMPORT_DEFN A , PS_RB_IMPT_RUNSPEC B , PS_RB_IMP_TYPE_TBL C WHERE A.LI_IMPORT_TYPE_ID = C.LI_IMPORT_TYPE_ID AND A.LI_IMPORT_ID = B.LI_IMPORT_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) AND A.LI_IMPT_STATUS = '02' |
| # | 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 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCR_AC | Character(30) | VARCHAR2(30) NOT NULL | Alternate Description |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | LI_IMPORT_TYPE_ID | Character(31) | VARCHAR2(31) NOT NULL | Import Tyoe ID (import with role) |