TABLE DETAIL REFERENCE: Department
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueFalse%s
FullName12 VARCHAR 1000TrueTrueTrueFalse%s
SubDepartment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ParentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
FullyQualifiedName12 VARCHAR 1000TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false