Refer to your Horizontal Menu:Bookmarks Account ACL Tools New
Mouseover New and select Table
Step #2
You will see a screen similar to what is below.- Name your table. Lower case -- no spaces.- Give it a description- Choose the appropriate folder. Root is the default.- Click AddNew This will add a column to your Table. If you don't click AddNew, you will accomplish 0. A Table must have at least 1 column. Though really columns, they will appear as initially appear as Rows - as shown below.
Step #3
Continue to add columns (AddNew). Name each column (lower case, no spaces), designate a datatype & give it a description as approropriate,
my_1st_table
testing for our employee benefit statements project.
----
Click AddNew to create a new column-- which will appear as a Row in this portion of the GUI.
name each column
choose datatype
see notes
see notes
add a description
1) Table and column names should be lowercase without spaces.2) Choose your datatypes. Think first.3) Length is only necessary for the type 'Numeric'. Example format: 7,2In this case, the maximum value would be 99999.99 where 7 is the total number of digits and 2 is the precision.4) NOT NULL means that you do not want the column to include any 'empty'. A NULL is ~ to 'clueless'. ee_id (employee id) would usually be designated NOT NULL.5) Default value to be 'auto entered' unless a specific value is entered. Example: Almost everyone live in California? Then a default for 'CA' may be appropriate.6) Description is always handy. YOU may know the meaning of an obscure code -- but someone else may be befuddled.
NOTES:
Tables are an essential building block of any Human Resources data system. Your employee census, payroll & personal employee benefits info are all stored inside of Tables.