CTM_Temps

9295 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Temp ID int 4 √ null
Home Region int 4 √ null
First Name varchar 100 √ null
Last Name varchar 100 √ null
Middle Name varchar 50 √ null
Maiden Name varchar 100 √ null
Nickname varchar 100 √ null
Address varchar 200 √ null
Address 2 varchar 200 √ null
City varchar 100 √ null
State varchar 50 √ null
Zip varchar 20 √ null
Country varchar 50 √ null
Address2 varchar 200 √ null
Address2 2 varchar 200 √ null
City 2 varchar 100 √ null
State 2 varchar 50 √ null
Zip 2 varchar 20 √ null
Phone Number varchar 50 √ null
Phone Number 2 varchar 50 √ null
Work Phone varchar 50 √ null
Cell Phone varchar 50 √ null
Other Phone varchar 50 √ null
Pager varchar 50 √ null
Fax varchar 50 √ null
Email varchar 100 √ null
Email 2 varchar 100 √ null
Emergency Contact varchar 100 √ null
Emergency Phone varchar 50 √ null
Emergency Relationship varchar 50 √ null
Status varchar 50 √ null
Temp Type varchar 100 √ null
SSN varchar 50 √ null
Date Of Birth varchar 20 √ null
Gender varchar 50 √ null
Race varchar 50 √ null
Date Hire varchar 50 √ null
Referral Source ID varchar 50 √ null
Referred By Name varchar 100 √ null
Recruiter varchar 500 √ null
Staffing Specialist varchar 200 √ null
Employee ID varchar 20 √ null
Certification varchar 4000 √ null
Specialty varchar 4000 √ null
Years Exp varchar 20 √ null
Resume varchar 20 √ null
Resume HTML varchar 20 √ null
Date Rehire varchar 50 √ null
Marital Status varchar 100 √ null
Employed At varchar 500 √ null
Date/Time Created varchar 50 √ null
Date/Time Modified varchar 50 √ null
Pay Schedule varchar 100 √ null
Veteran Status varchar 100 √ null
PRN/Travel int 4 √ null
ADP ID varchar 200 √ null
PeopleSoft ID varchar 200 √ null
PeachTree ID varchar 200 √ null
Send Mass Emails int 4 √ null
How Pay varchar 200 √ null
How Pay Amount varchar 200 √ null
How Pay Amount Bill varchar 200 √ null
Burden Amount varchar 200 √ null
Burden Type varchar 200 √ null
Primary Certification varchar 200 √ null
AVA_insdate datetime2 16 √ (getdate())

Diagram producer might be missing

No diagrams were produced please see application output for any errors