CL_BATCH_IDPrompt Table: LN_CL_BATOUT_VW
CL_IMP_BATCH_VW(SQL View) |
Index Back |
|---|---|
CL import batch viewThis view is used for prompting on the CL import batch id. |
| SELECT DISTINCT CL_BATCH_ID, CL_FILE_TRANS_DT, LOAN_TRANS_DTTM FROM PS_CL_IMP_HEAD_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 | LOAN_TRANS_DTTM | DateTime(26) | TIMESTAMP | Loan Trans Date/Time |