Government Database Tables and Columns 45
PLUSRFORM Table
PLUSRFORMTRANS Table
DELETIONS 1 DECIMAL 15
ENDINGACQCOST 1 DECIMAL 15
ENDINGQUANTITY 1 INTEGER 12
MISSINGUIIACQCOST 1 DECIMAL 15
MISSINGUIIQUANTITY 1 INTEGER 12
ORGID 1 UPPER 8
PLUSRCONTSUMMARYID 1 INTEGER 12
PROPERTYCLASS 1 UPPER 25
COLUMN REQUIRED MAXTYPE LENGTH
COLUMN REQUIRED MAXTYPE LENGTH
CREATEDDATE 1 DATETIME 10
CREATEDPERSONID 1 UPPER 30
FILENAME 1 UPPER 25
FORMNAME 1 UPPER 25
ORGID 1 UPPER 8
PATHNAME 0 ALN 500
PLUSRFORMID 1 INTEGER 12
PROPERTYTRANSID 1 INTEGER 12
SITEID 1 UPPER 8
COLUMN REQUIRED MAXTYPE LENGTH
EMAIL 0 ALN 100
FORMID 1 INTEGER 12
ORGID 1 UPPER 8
PLUSRFORMTRANSID 1 INTEGER 12
SITEID 1 UPPER 8
STATUS 1 UPP ER 25
TRANSACTIONDATE 1 DATETIME 10
TRANSPERSONID 1 UPPER 30