Employee Benefit Statements
ProceduresDocument CollectionData CollectionTutorial for Doing-it-YourselfSamples & ExamplesAn Employee Website + more
Click here for the Index
Employee Communications
A variety of Targeted Examples, ranging from an online Employee Budget Worksheet, to Retirement Communications, online Enrollment & much more.
Click here for the Index
The Human Resources Collaborative Suite
Why it's neededTools we usedYour ToolsOverview and IntroductionMovies and more
Click here for the Index
 New Table
Step #1
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.
Have a Question?
Your email
Employee Benefit Statements An onlineEmployee Budget Worksheet Collaborate.Easily,productively
Please wait...