!Conversion Terminology \\ %%center %%small __GO TO__ ||[A|1] [B|2] [C|3] [D|4] [E|5] [F|6] [G|7] [H|8] [I|9] [J|10] [K|11] [L|12] [M|13] [N|14] [O|15] [P|16] [Q|17] [R|18] [S|19] [T|20] [U|21] [V|22] [W|23] [X|24] [Y|25] [Z|26]%% %% \\ !![A|#1] ---- ''No Terminology'' \\ !![B|#2] ---- ''No Terminology'' \\ !![C|#3] ---- ;Char: A character column contains a sequence of letters, numbers, punctuation and special characters. In most cases, the character column is of a variable length up to the size indicated. These variable length fields are identified as VarChar2 !![D|#4] ---- ;Date: Date columns must contain a valid date and (optionally) a time of day. The feeder program generally indicates the format of the date. The software default incorporates a two digit day, a three letter month abbreviation and a four digit year, separated by hyphens (14-Dec-1987) !![E|#5] ---- ''No Terminology'' \\ !![F|#6] ---- ;Feeder program:A feeder program is a program that is used to import your data from an external legacy or feeder system into the software application. The type of feeder program used depends upon the environment from which you are importing data and the MIS resources you have available. SQL*Loader is a feeder program that is delivered with your Oracle Server software and will meet many of the needs of your imports. !![G|#7] ---- ''No Terminology'' \\ !![H|#8] ---- ''No Terminology'' \\ !![I|#9] ---- ;Interface Tables:Data is not interfaced directly into the software data structures, but is loaded into interface tables. There is then a process that will take the data from these interface tables and move it into the related software data structures. !![J|#10] ---- ''No Terminology'' \\ !![K|#11] ---- ''No Terminology''\\ !![L|#12] ---- ''No Terminology''\\ !![M|#13] ---- ''No Terminology''\\ !![N|#14] ---- ;Number:A number column contains a number consisting of digits, a sign and a decimal point. Number fields are shown as having two attributes: a length (including the decimal point and sign) and a maximum number of decimals. For example a field that is shown as Number (18,6) can have a total of 18 characters in the field, of which up to six may be after the decimal point. If a number field has only one attribute, then there are no decimal points allowed. !![O|#15] ---- ''No Terminology''\\ !![P|#16] ---- ''No Terminology''\\ !![Q|#17] ---- ''No Terminology''\\ !![R|#18] ---- ''No Terminology''\\ !![S|#19] ---- ''No Terminology''\\ !![T|#20] ---- ''No Terminology''\\ !![U|#21] ---- ''No Terminology''\\ !![V|#22] ---- ''No Terminology''\\ !![W|#23] ---- ''No Terminology''\\ !![X|#24] ---- ''No Terminology''\\ !![Y|#25] ---- ''No Terminology''\\ !![Z|#26] ---- ''No Terminology''\\ ---- ![Notes|Edit:Internal.TERMINOLOGY-CV] [{InsertPage page='Internal.TERMINOLOGY-CV' default='Click to create a new notes page'}]