CL_BATCH_IDPrompt Table: LN_CL_BATOUT_VW
CL4_IMP_BAT_VW(SQL View) |
Index Back |
|---|---|
CL import batch viewThis view is used for prompting on the CL4 import batch id. |
| SELECT DISTINCT CL_BATCH_ID, CL_FILE_TRANS_DT, CL_LOAD_DTTM FROM PS_CL_DSB_HEAD4_EC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CL_BATCH_ID |
Character(12) | VARCHAR2(12) NOT NULL |
CommonLine Batch ID
Prompt Table: LN_CL_BATOUT_VW |
| 2 | CL_FILE_TRANS_DT | Date(10) | DATE | File Transmission Date |
| 3 | CL_LOAD_DTTM | DateTime(26) | TIMESTAMP | Loan Batch Load Dttm |