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 | Added by system - not required in inbound file. |
CREATE_USER | VARCHAR2(30) | VARCHAR30 | Y | Added by system - not required in inbound file. |
CREATE_DATE | DATE | DATE | Y | Added by system - not required in inbound file. |
CHANGE_USER | VARCHAR2(30) | VARCHAR30 | Y | Added by system - not required in inbound file. |
CHANGE_DATE | DATE | DATE | Y | Added by system - not required in inbound file. |
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 |