This page (revision-8) was last changed on 23-Mar-2023 09:57 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by khiggs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
8 23-Mar-2023 09:57 7 KB Kevin Higgs to previous
7 23-Mar-2023 09:56 7 KB Kevin Higgs to previous | to last
6 26-Nov-2021 10:22 7 KB rforbes to previous | to last
5 26-Nov-2021 10:22 7 KB rforbes to previous | to last
4 26-Nov-2021 10:22 6 KB rforbes to previous | to last
3 26-Nov-2021 10:22 6 KB rforbes to previous | to last
2 26-Nov-2021 10:22 6 KB rforbes to previous | to last
1 26-Nov-2021 10:22 5 KB khiggs to last

Page References

Incoming links Outgoing links
INF_UT_LOADS...nobody
INF_UT_LOADS

Version management

Difference between version and

At line 1 changed one line
!!!Alias: ULD
!!!Alias: [ULD]
At line 5 changed one line
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.
Used for Generic file loading
At line 7 removed 2 lines
The data loaded onto this table can be reviewed on the [IULF] form within personality.
At line 12 changed 6 lines
|[ID]|NUMBER(10,0)| [ID]|Y|Added by system - not required in inbound file.
|[CREATE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|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|VARCHARnn]|Y|Added by system - not required in inbound file.
|[CHANGE_DATE]|DATE| [DATE]|Y|Added by system - not required in inbound file.
|[STATUS|STATUS (ULD)]|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.
|[CHANGE_DATE]|DATE| [DATE]|Y|
|[CREATE_DATE]|DATE| [DATE]|Y|
|[ID]|NUMBER(10,0)| [ID]|Y|
|[STATUS|STATUS (ULD)]|VARCHAR2(100)| [VARCHARnn]| |
|[CHANGE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[CREATE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
At line 101 changed one line
|[COLUMN84|COLUMNnn]|VARCHAR2(4000)| [VARCHAR4000|VARCHARnn]| |
|[COLUMN84]|COLUMNnn|VARCHAR2(4000)| [VARCHAR4000|VARCHARnn]| |
This page (revision-8) was last changed on 23-Mar-2023 09:57 by Kevin HiggsTop