Alias: ULD#
(INF_UT_LOADS)Used for Generic file loading. This table is intended to be loaded with external data using SQL*Loader or the LMTD function and then subsequently processed as needed by a PL/SQL procedure that is custom built for the purpose.
The data loaded onto this table can be reviewed on the IULF form within personality.
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | NUMBER(10,0) | ID | Y | |
| CREATE_USER | VARCHAR2(30) | VARCHAR30 | Y | |
| CREATE_DATE | DATE | DATE | Y | |
| CHANGE_USER | VARCHAR2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | DATE | DATE | Y | |
| STATUS | VARCHAR2(100) | VARCHARnn | The value of this field is typically an identifier for error handling in customer custom PL/SQL programs that work with the data on this table. Some clients have multiple processes making use of this custom table, as a reuslt this field is often used to filter records based on the processthe custom information being loaded. This allows clients to make a copy of the IULF and limit the data being displayed via a where clause added to the form definition. Example - If your process is a custom benefit load, the value "BENEFIT" may be loaded into this field. If you are using this table to update accrual information the value "AT" may be used. | |
| COLUMN01 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN02 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN03 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN04 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN05 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN06 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN07 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN08 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN09 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN10 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN11 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN12 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN13 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN14 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN15 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN16 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN17 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN18 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN19 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN20 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN21 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN22 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN23 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN24 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN25 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN26 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN27 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN28 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN29 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN30 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN31 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN32 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN33 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN34 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN35 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN36 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN37 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN38 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN39 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN40 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN41 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN42 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN43 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN44 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN45 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN46 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN47 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN48 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN49 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN50 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN51 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN52 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN53 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN54 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN55 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN56 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN57 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN58 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN59 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN60 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN61 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN62 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN63 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN64 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN65 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN66 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN67 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN68 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN69 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN70 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN71 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN72 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN73 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN74 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN75 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN76 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN77 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN78 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN79 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN80 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN81 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN82 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN83 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN84 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN85 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN86 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN87 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN88 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN89 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN90 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN91 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN92 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN93 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN94 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN95 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN96 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN97 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN98 | VARCHAR2(4000) | VARCHAR4000 | ||
| COLUMN99 | VARCHAR2(4000) | VARCHAR4000 |
Notes #
Click to create a new notes pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation