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 |
