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 nameData Type / SizeDomain Mand.Notes
IDNUMBER(10,0) IDYAdded by system - not required in inbound file.
CREATE_USERVARCHAR2(30) VARCHAR30YAdded by system - not required in inbound file.
CREATE_DATEDATE DATEYAdded by system - not required in inbound file.
CHANGE_USERVARCHAR2(30) VARCHAR30YAdded by system - not required in inbound file.
CHANGE_DATEDATE DATEYAdded by system - not required in inbound file.
STATUSVARCHAR2(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.
COLUMN01VARCHAR2(4000) VARCHAR4000
COLUMN02VARCHAR2(4000) VARCHAR4000
COLUMN03VARCHAR2(4000) VARCHAR4000
COLUMN04VARCHAR2(4000) VARCHAR4000
COLUMN05VARCHAR2(4000) VARCHAR4000
COLUMN06VARCHAR2(4000) VARCHAR4000
COLUMN07VARCHAR2(4000) VARCHAR4000
COLUMN08VARCHAR2(4000) VARCHAR4000
COLUMN09VARCHAR2(4000) VARCHAR4000
COLUMN10VARCHAR2(4000) VARCHAR4000
COLUMN11VARCHAR2(4000) VARCHAR4000
COLUMN12VARCHAR2(4000) VARCHAR4000
COLUMN13VARCHAR2(4000) VARCHAR4000
COLUMN14VARCHAR2(4000) VARCHAR4000
COLUMN15VARCHAR2(4000) VARCHAR4000
COLUMN16VARCHAR2(4000) VARCHAR4000
COLUMN17VARCHAR2(4000) VARCHAR4000
COLUMN18VARCHAR2(4000) VARCHAR4000
COLUMN19VARCHAR2(4000) VARCHAR4000
COLUMN20VARCHAR2(4000) VARCHAR4000
COLUMN21VARCHAR2(4000) VARCHAR4000
COLUMN22VARCHAR2(4000) VARCHAR4000
COLUMN23VARCHAR2(4000) VARCHAR4000
COLUMN24VARCHAR2(4000) VARCHAR4000
COLUMN25VARCHAR2(4000) VARCHAR4000
COLUMN26VARCHAR2(4000) VARCHAR4000
COLUMN27VARCHAR2(4000) VARCHAR4000
COLUMN28VARCHAR2(4000) VARCHAR4000
COLUMN29VARCHAR2(4000) VARCHAR4000
COLUMN30VARCHAR2(4000) VARCHAR4000
COLUMN31VARCHAR2(4000) VARCHAR4000
COLUMN32VARCHAR2(4000) VARCHAR4000
COLUMN33VARCHAR2(4000) VARCHAR4000
COLUMN34VARCHAR2(4000) VARCHAR4000
COLUMN35VARCHAR2(4000) VARCHAR4000
COLUMN36VARCHAR2(4000) VARCHAR4000
COLUMN37VARCHAR2(4000) VARCHAR4000
COLUMN38VARCHAR2(4000) VARCHAR4000
COLUMN39VARCHAR2(4000) VARCHAR4000
COLUMN40VARCHAR2(4000) VARCHAR4000
COLUMN41VARCHAR2(4000) VARCHAR4000
COLUMN42VARCHAR2(4000) VARCHAR4000
COLUMN43VARCHAR2(4000) VARCHAR4000
COLUMN44VARCHAR2(4000) VARCHAR4000
COLUMN45VARCHAR2(4000) VARCHAR4000
COLUMN46VARCHAR2(4000) VARCHAR4000
COLUMN47VARCHAR2(4000) VARCHAR4000
COLUMN48VARCHAR2(4000) VARCHAR4000
COLUMN49VARCHAR2(4000) VARCHAR4000
COLUMN50VARCHAR2(4000) VARCHAR4000
COLUMN51VARCHAR2(4000) VARCHAR4000
COLUMN52VARCHAR2(4000) VARCHAR4000
COLUMN53VARCHAR2(4000) VARCHAR4000
COLUMN54VARCHAR2(4000) VARCHAR4000
COLUMN55VARCHAR2(4000) VARCHAR4000
COLUMN56VARCHAR2(4000) VARCHAR4000
COLUMN57VARCHAR2(4000) VARCHAR4000
COLUMN58VARCHAR2(4000) VARCHAR4000
COLUMN59VARCHAR2(4000) VARCHAR4000
COLUMN60VARCHAR2(4000) VARCHAR4000
COLUMN61VARCHAR2(4000) VARCHAR4000
COLUMN62VARCHAR2(4000) VARCHAR4000
COLUMN63VARCHAR2(4000) VARCHAR4000
COLUMN64VARCHAR2(4000) VARCHAR4000
COLUMN65VARCHAR2(4000) VARCHAR4000
COLUMN66VARCHAR2(4000) VARCHAR4000
COLUMN67VARCHAR2(4000) VARCHAR4000
COLUMN68VARCHAR2(4000) VARCHAR4000
COLUMN69VARCHAR2(4000) VARCHAR4000
COLUMN70VARCHAR2(4000) VARCHAR4000
COLUMN71VARCHAR2(4000) VARCHAR4000
COLUMN72VARCHAR2(4000) VARCHAR4000
COLUMN73VARCHAR2(4000) VARCHAR4000
COLUMN74VARCHAR2(4000) VARCHAR4000
COLUMN75VARCHAR2(4000) VARCHAR4000
COLUMN76VARCHAR2(4000) VARCHAR4000
COLUMN77VARCHAR2(4000) VARCHAR4000
COLUMN78VARCHAR2(4000) VARCHAR4000
COLUMN79VARCHAR2(4000) VARCHAR4000
COLUMN80VARCHAR2(4000) VARCHAR4000
COLUMN81VARCHAR2(4000) VARCHAR4000
COLUMN82VARCHAR2(4000) VARCHAR4000
COLUMN83VARCHAR2(4000) VARCHAR4000
COLUMN84VARCHAR2(4000) VARCHAR4000
COLUMN85VARCHAR2(4000) VARCHAR4000
COLUMN86VARCHAR2(4000) VARCHAR4000
COLUMN87VARCHAR2(4000) VARCHAR4000
COLUMN88VARCHAR2(4000) VARCHAR4000
COLUMN89VARCHAR2(4000) VARCHAR4000
COLUMN90VARCHAR2(4000) VARCHAR4000
COLUMN91VARCHAR2(4000) VARCHAR4000
COLUMN92VARCHAR2(4000) VARCHAR4000
COLUMN93VARCHAR2(4000) VARCHAR4000
COLUMN94VARCHAR2(4000) VARCHAR4000
COLUMN95VARCHAR2(4000) VARCHAR4000
COLUMN96VARCHAR2(4000) VARCHAR4000
COLUMN97VARCHAR2(4000) VARCHAR4000
COLUMN98VARCHAR2(4000) VARCHAR4000
COLUMN99VARCHAR2(4000) VARCHAR4000


Notes #

Click to create a new notes page