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
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.
At line 7 added 2 lines
The data loaded onto this table can be reviewed on the [IULF] form within personality.
At line 10 changed 6 lines
|[CHANGE_DATE]|DATE| [DATE]|Y|
|[CREATE_DATE]|DATE| [DATE]|Y|
|[ID]|NUMBER(10,0)| [ID]|Y|
|[STATUS|STATUS (ULD)]|VARCHAR2(100)| [VARCHAR100]| |
|[CHANGE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[CREATE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[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.
At line 99 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