Skip to content

Student Manager Data Structure

A list of Student Manager tables and fields within the table. Most fields are listed by the label that appears on the associated screen. The exception to this rule are fields that can be relabeled by the organization (e.g. cocoord, nmmisc, all udfs fields).

ATTEND

LabelField NameTypeLengthDecimals
Attendance CodeATCODEC60
Course CodeATCRSEC120
GradeATGRADEC30
IDATIDC90
ModuleATMODULEC120
NameATNAMEC750
Session DateATDATED80
Session HoursATHOURSN42

BUDGET

LabelField NameTypeLengthDecimals
Course CodeBUCRSEC120
Estimated Enrollment for FeeBUFEENUMN40
Fee AmountBUFEEAMTN90
Fee LabelLBUFEEDESCC250
Fee TypeBUFEETYPEC10

CATALOG

LabelField NameTypeLengthDecimals
ActiveCAACTIVEL10
Add DateCAADDATED80
AudienceCAAUDIENCEM100
Begin DateCABEGDATED80
Begin TimeCABEGTIMEC50
BenefitsCABENEFITSM100
Bio/CredentialsCABIOM100
CodeCACODEC100
Contact EmailCACEMAILC500
Contact NameCACNAMEC500
Contact PhoneCACPHONEC200
Web AddressCAWEBADDRC750
Created ByCACREATORC80
End TimeCAENDTIMEC50
FeeCAPROPFEEN82
FeaturesCAFEATURESM100
GraphicCAPICC750
HoursCAHOURSN72
Instructor ExpensesCAINEXPM100
KindCAKINDC10
LocationCALOCC400
MaterialsCAMATERIALM100
NameCANAMEC950
Optional 1CAOPT1C950
Optional 2CAOPT2C950
Prerequisite DescriptionCAPREREQM100
Primary DescriptionCADESCM100
Publish on Web?CAPUBLISHL10
ScheduleCASCHEDULEC600
Secondary Description (Web)CADESC2M100
# of SessionsCASESSN30
StatusCASTATUSC100
Subject CodeCASUBJC80
Text BookCATEXTC1000
ThumbnailCATHUMBM100
Updated ByCAUSERC80
Update DateCAUPDATED80

CATGROUP

LabelField NameTypeLengthDecimals
Catalog CodeCGCATALOGC120
Grouping CodeCGCODEC60

CHOICES

LabelField NameTypeLengthDecimals
Active Code?CHACTIVEL10
ChoiceCHOICEC150
Cost of PromotionCOSTN60
CreatorCREATORC80
DescriptionDISCRIPTC500
DetailCHMEMOM100
IdentifierIDENTIFIERC300
Major Expense CategoryTIMEUPDATEC80
Number of BrochuresNO_BROCHN60
Order PointORDERPTN40
Promotion DateDATEUPDATED80
Scope ByINTIDENTC10
Show/Hide from WebMARKEDL10
Specific Course/File Name for ImageCRSEC120
UpdatedUPDATED80
UserUSERC80

COURSE

LabelField NameTypeLengthDecimals
Account CodeCOACCOUNTC300
ACEweb Publish PropertiesCOWEBREGN10
Active FlagCOACTIVEL10
Add DateCOADDATED80
Age RequirementCOAGEREQN20
Allow Web WaitlistCOWEBWAITL10
Alternate Display Course CodeCOALIASC320
Attachment (email receipt)CORECATTC2500
Begin DateCOBEGDATED80
Budget Add DateCOBUADDD80
Budget BreakevenCOBUBREAKN50
Budget Go No-GoCOBUNOGON50
Budget NotesCOBUNOTEC1000
Budget OverheadCOBUOVERN20
Budget Profit ShareCOBUSHAREN20
Budget UpdatedCOBUUPDATED80
Budget UserCOBUUSERC80
Canceled FlagCOCANCELL10
Catalog CodeCOCATCODEC100
CategoryCOCATEGORYC120
CEUSCOCEUSN73
Comments (Reminder Note)CONOTENPRTM100
CoordinatorCOCOORDC200
Course CodeCOCRSEC120
Course TimeCOCRSETMC850
Created ByCOCREATORC80
CreditsCOCREDITN41
Date Opened for EnrollmentCOOPENDATD80
Days of WeekCODOWC70
DepartmentCODEPTC350
Email Reminders to StudentsCOEREMFLL10
Email Reminders DatetimeCOREMDTD80
End DateCOENDDATED80
End HoursCOENDHRSN20
End MinutesCOENDMINN20
Enrollment CountCOENROLLEDN50
Estimated EnrollmentCOESTENRLN40
Gift Exp DateCOGIFTEXPDD80
Gift Exp DaysCOGIFTEXPNN40
Group CountCOGRPCTN50
HoursCOHOURSN72
Instructor ID (No longer in use)COINSTIDC120
Lag Days for ACEwebCOWEBLAGN30
Lag Days for Billing on ACEwebCOBILLAGN30
Location IDCOLOCIDC120
Locked FlagCOLOCKEDL10
Maximum SizeCOMAXN50
Membership RequisitesCOMEMREQC1000
Merchant NumberCOMERCNUMC150
Minimum SizeCOMINN30
Months to CompleteCOEXPTIMEN20
Must Logon to View (Express)COLOGFIRSTL10
New Course FlagCONEWL10
Note (Printed on Receipt)CONOTEPRTM100
Online Course ProviderCOSERVICEC30
Online NoteCONOTEONLM100
Persons to Notify Via ACEwebCONOTIFYC1500
Physical MaxCOPHYSMAXN30
Print Location FlagCOLOCPRTINL10
Publish DateCOPUBDATED80
Proxy TypeCOPROXYTYPC100
Qualifies for Tax Credit FlagCOTAXCRL10
Reason Course was CanceledCOWHYCXC500
Receipt TemplateCORECCODEC100
Reference DocumentCOREFDOCC1000
Registration TimeCOREGTIMEC800
Registration Warning MessageCOREGWARNC800
Registrant Information Shown on ACEweb
RostersCOLISTCLASM100
Remind WhenCOREMWHEND80
Remind WhoCOREMWHOC80
Sessions NumberCOSESSN30
Short TitleCOSHORTNMC300
Show on Web TranscriptCOWEBTRANN10
Settings for ACEweb Special FunctionsCOWEBCFGM100
Special ACEweb Data Capture PageCOWEBCARDC200
Special ACEweb Information PageCOWEBSTATC200
Sponsoring FirmCOFMIDC120
Start HourCOSTHRSN20
Start MinuteCOSTMINN20
Subject CodeCOSUBCODEC80
TitleCOCRSENMC1250
Track AttendanceCOTRKATTL10
TypeCOTYPEC120
Update DateCOUPDATED80
Update TimeCOUPTMC100
Updated ByCOUSERC80
URLCOURLC2500
Waitlist CountCOWAITNUMN50
Web CertificateCOWEBCERTC500
Web Grade Book Access LevelCOWEBGRADEN10
Web Workshop MessageCOWEBWKMSGM100
Workshop Enabled (No Longer Used)COWKSHOPL10
Workshop MaximumCOWKMAXN20
Workshop MinimumCOWKMINN20
Additional Character Field (label specified by organization)COCHAR1C150

CREDINDV

LabelField NameTypeLengthDecimals
Course CodeCICRSEC120
Credit CodeCICODEC80
IDCIIDC90
NoteCINOTEC300
TypeCITYPEC60
UnitsCIUNITN62

CREDMAST

LabelField NameTypeLengthDecimals
Course CodeCMCRSEC120
TypeCMTYPEC60
UnitsCMUNITN62
Credit CodeCMCODEC80
NoteCMNOTEC300

CRM

LabelField NameTypeLengthDecimals
CourseCRCRSEC120
DateCRDATED80
IDCRIDC90
SubjectCRSUBJECTC600
TypeCRTYPEC10
UserCRUSERC80

CRSEREM

LabelField NameTypeLengthDecimals
Course CodeREMCRSEC120
Remind Who?REMWHOC80
When?REMWHEND80
Reminder NoteREMNOTESM100
OIDREMOIDC120

CRSEUDFS

Label UDFs on the UDF screen. See the Course-specific Labels topic for information on labeling Course Specific Registration Labels.

LabelField NameTypeLengthDecimals
Course CodeCUCRSEC120
User defined Character 1CUDFC1C350
User defined Character 2CUDFC2C350
User defined Character 3CUDFC3C500
User defined Character 4CUDFC4C700
User defined Date 1CUDFD1D80
User defined Date 2CUDFD2D80
User defined Date 3CUDFD3D80
User defined Date 4CUDFD4D80
User defined Logical 1CUDFL1L10
User defined Logical 2CUDFL2L10
User defined Logical 3CUDFL3L10
User defined Logical 4CUDFL4L10
User defined Numeric 1CUDFN1N82
User defined Numeric 2CUDFN2N82
User defined Numeric 3CUDFN3N82
User defined Numeric 4CUDFN4N82
Course Specific Character 1 Registration LabelCULBLC1C150
Course Specific Character 2 Registration LabelCULBLC2C150
Course Specific Character 3 Registration LabelCULBLC3C150
Course Specific Character 4 Registration LabelCULBLC4C150
Course Specific Date 1 Registration LabelCULBLD1C150
Course Specific Date 2 Registration LabelCULBLD2C150
Course Specific Date 3 Registration LabelCULBLD3C150
Course Specific Date 4 Registration LabelCULBLD4C150
Course Specific Logical 1 Registration LabelCULBLL1C150
Course Specific Logical 2 Registration LabelCULBLL2C150
Course Specific Logical 3 Registration LabelCULBLL3C150
Course Specific Logical 4 Registration LabelCULBLL4C150
Course Specific Numeric 1 Registration LabelCULBLN1C150
Course Specific Numeric 2 Registration LabelCULBLN2C150
Course Specific Numeric 3 Registration LabelCULBLN3C150
Course Specific Numeric 4 Registration LabelCULBLN4C150

CRSROOM

LabelField NameTypeLengthDecimals
Add DateCRMADDDATED80
Course CodeCRMCRSEC120
Created ByCRMCREATORC80
DateCRMDATED80
End HoursCRMENDHRSN20
End MinutesCRMENDMINN20
Location IDCRMLOCIDC120
Start HoursCRMSTHRSN20
Start MinutesCRMSTMINN20
TimeCRMTMC300
UpdatedCRMUPDATED80
Updated ByCRMUSERC80

FEES

LabelField NameTypeLengthDecimals
AmountFEFEEN92
Coupon/Inventory
CodeFEINVNOC80
Course CodeFECRSEC120
Expires (days)FEEXPN40
Fee DescriptionFEDESCC500
Hide from Web FlagFEWEBHIDEL10
HybridFEHYBRIDC10
Mandatory FlagFEAUTOL10
OrderFEORDERN20
TypeFEIDENTC10
MaxFEMAXN40
Member Expires (Date)FETERMDATED80
Member Expires (# of Days)FETERMOFFN50
Member CodeFEMEMCODEC100

FINAIDI

LabelField NameTypeLengthDecimals
Add DateFAIADDATED8
Amount ExpectedFAIEXPECTN82
Date ExpectedFAIEXPECTDD8
Course AppliedFAICRSEC12
ID (Name)FAIIDC9
NotesFAINOTEC100
ReceivedFAIRECEIVEN82
Updated ByFAIUSERC8
Update DateFAIUPDATED8

FINAIDM

LabelField NameTypeLengthDecimals
Award DateFAMAWARDEDD8
Date AddedFAMADDATED8
EFCFAMEFCN82
ID (Name)FAMIDC9
Payment TypeFAMPYTYPEC1
ReturnedFAMRETURN182
Total ExpectedFAMTOTALN82
TypeFAMTYPEC30
UpdatedFAMUPDATED8
Updated ByFAMUSERC8

FIRM

LabelField NameTypeLengthDecimals
# of EmployeesFMEMPLOYN50
$ CreditsFMCREDITSN92
Add DateFMADDATED80
Additional InformationFMEXTRAC650
Address Line 1FMADDR1C500
Address Line 2FMADDR2C500
Bill Address Line 1FMBADDR1C500
Bill Address Line 2FMBADDR2C500
Bill CityFMBCITYC170
Bill CountryFMBCNTRYC200
Bill PhoneFMBPHONEC150
Bill StateFMBSTATEC20
Bill to Attention ofFMBATTNC300
Bill ZipFMBZIPC100
CityFMCITYC170
CommentsFMCOMMM100
ContactFMCONTACTC750
Contact 2FMCONTACT2C750
CountyFMCOUNTYC150
CountryFMCNTRYC200
EmailFMEMAILC600
Email 2FMEMAIL2C600
Fax PhoneFMFPHONEC150
Federal IDFMFEDIDC120
Fee CategoryFMFEECATC300
Firm NameFMFIRMC750
Firm IDFMIDC120
Firm RepresentativeFMREPC60
Link FileFMLINKFILEC500
Org CodeFMORGC60
Parent CompanyFMCORPC350
PhoneFMPHONEC150
ProvinceFMPROVINCEC200
Qualification CodeFMQUALIFYC20
SICFMSICC90
Size (in $000’s)FMSIZEN70
StateFMSTATEC20
TypeFMIDENTC10
Update DateFMUPDATED80
URLFMURLC750
UserFMUSERC80
ZipFMZIPC100
Firm Character Field 1 (label specified by organization)FMCHAR1C120
Firm Character Field 2 (label specified by organization)FMCHAR2C120
Firm Logical Field 1 (label specified by organization)FMLOG1L10
Firm Logical Field 2 (label specified by organization)FMLOG2L10

GIFTCARD

LabelField NameTypeLengthDecimals
NumberGCNUMC80
Sub IDGCSUBIDC120
UsedGCUSEDL10
NotesGCNOTESM100
Name IDGCIDC90
Expiration DateGCEXPIRED80

GROUPING

LabelField NameTypeLengthDecimals
Course CodeGRCRSEC120
Grouping CodeGRCODEC60

HOLIDAYS

LabelField NameTypeLengthDecimals
DateDATED80
DescriptionDESCRIPTC300
Local HolidayLOC_HOLC400
ThroughDATE2D80
Start HourHOURN20
Start MinutesMINUTEN20

INSTRUCT

Label UDFs on the UDF screen.

LabelField NameTypeLengthDecimals
ACEweb Edit LevelINLEVELN10
Active FlagINPRTLBLL10
Add DateINADDATED80
Address Line 1INADDR1C500
Address Line 2INADDR2C500
Available Friday FlagINAVLFRIL10
Available Monday FlagINAVLMONL10
Available Saturday FlagINAVLSATL10
Available Sunday FlagINAVLSUNL10
Available Thursday FlagINAVLTHUL10
Available Tuesday FlagINAVLTUEL10
Available Wednesday FlagINAVLWEDL10
BioINBIOM100
Call Back DateINCALLBACKD80
Cell PhoneINCELLPHC150
CityINCITYC170
Code 1INCODE1C120
CommentsINCOMMM100
CountryINCNTRYC200
Day PhoneINDPHONEC150
Email AddressINEMAILC600
Employment StatusINUDFN1N82
Evaluation NotesINEVALNOTEM100
Faculty System IDINSTIDC120
Fax PhoneINFPHONEC150
Firm IDINFMIDC120
FirmINFIRMC750
First NameINNAME1C150
Give out Day Phone FlagINGIVEDPHOL10
Give out Email FlagINGIVEEML10
Give out Home Phone FlagINGIVEHPHOL10
Give out Cell Phone FlagINGIVECELLL10
Home PhoneINHPHONEC140
HTMLINHTMLM100
ID #INIDC90
ID/FEININSSNC110
Last NameINNAME3C300
Middle NameINNAME2C120
Occupation CodeINOCCC60
Organization CodeINORGC60
Pager NumberINPAGERC150
Payment NotesINPAYNOTEM100
Prefer M of CINPMOCC10
Print Label FlagINLABELL10
ProvinceINPROVINCEC200
Reference DocumentINREFERENC1000
ResumeINRESUMEC1000
SalutationINSALUTC40
Schedule ExceptionsINSCHEDULEC700
SkillsINSKILLC1000
Source CodeINSOURCEC60
Staff ContactINHANDLERC150
StateINSTATEC20
SuffixINSUFFC100
TitleINTITLEC500
Update DateINUPDATED80
UserINUSERC80
User Defined Character 1 (Pay Type)INUDFC1C200
User Defined Character 2INUDFC2C200
User Defined Character 3INUDFC3C200
User Defined Character 4INUDFC4C600
User Defined Date 1INUDFD1D80
User Defined Date 2INUDFD2D80
User Defined Date 3INUDFD3D80
User Defined Date 4INUDFD4D80
User Defined Logical 1INUDFL1L10
User Defined Logical 2INUDFL2L10
User Defined Logical 3INUDFL3L10
User Defined Logical 4INUDFL4L10
User Defined Numeric 2INUDFN2N82
User Defined Numeric 3INUDFN3N82
User Defined Numeric 4INUDFN4N82
View Student Email (on ACEweb)?INSHOWEML10
Who Should Call BackINWHOCALLC80
ZipINZIPC100

LEDGDESC

LabelField NameTypeLengthDecimals
Cost Center CodeLDCODEC120
Cost Center DescriptionLDDESCC550

LEDGENTR

LabelField NameTypeLengthDecimals
Account CodeLEACCTNUMC300
AmountLEAMTN102
Budget Expense TypeLETYPEC10
Budget Record IDLEBUOIDC100
Cost Center CodeLECODEC120
Date of ExpenseLEDATED80
Date PostedLEPOSTDATED80
DescriptionLEDESCC1250
Expense ClassificationLECLASSC60
Expense or Income FlagLEEXP_INCL10
Group IDLEGROUPIDC120
Item Received FlagLERCVDL10
Major Expense CategoryLECATC20
Other DetailLEDETAILC200
Paid FlagLEPAIDL10
PO NumberLEPONUMC100
Projected or Actual FlagLEPROJL10
QuantityLEQTYN50
Receipt #LERECNUMC120
UserLEUSERC80
Vendor IDLEVENIDC120
Vendor NameLEVENDNMC750

LINKINST

LabelField NameTypeLengthDecimals
# of Class SessionsLISESSN30
Account CodeLIACCOUNTC300
Amount to deduct from Gross or Net payLIPYDEDUCTN92
CommentsLICOMMC600
Course CodeLICRSEC120
Date PaidLIDATEPAIDD80
Evaluation Criteria 1LIEV1N30
Evaluation Criteria 2LIEV2N30
Evaluation Criteria 3LIEV3N30
Evaluation Criteria 4LIEV4N30
Evaluation Criteria 5LIEV5N30
Evaluation Criteria 6LIEV6N30
Evaluation Criteria 7LIEV6N30
Expense ClassificationLICLASSC60
Faculty member Flag (No Longer Used)LIFACULTYL10
Group IDLIGROUPIDC120
Hours teachingLIHOURSN72
Instructor IDLIINSTIDC120
Miscellaneous Pay DescriptionLIMISCDESCC300
Miscellaneous PaymentLIMISCPAYN72
Pay NotesLIPAYNOTEC2500
Payment DateLIPAYDATED80
Payment RateLIPAYRATEN82
Payment TypeLIPAYTYPEC10
Percent of ClassLIPERCENTN62
Presentation DateLIPRESDATED80
Presentation TimeLIPRESTIMEC850
Presentation TitleLIPRESTITLC950
Presentation TypeLIPRESTYPEC170
Presentation VenueLIPRESVENUC400
Ref (%age)LIPAYREFN70
UserLIUSERC80

LOCATION

LabelField NameTypeLengthDecimals
ActiveLOCACTIVEL10
Additional (ACEweb) InformationLOCHTMLM100
Address Line 1LOCADDR1C360
Address Line 2LOCADDR2C300
Building/RoomLOCLOCATC550
CampusLOCCAMPUSC300
Character 1LOCUDF1C500
Character 2LOCUDF2C900
CityLOCCITYC200
ContactLOCCONTACTC500
CountyLOCCOUNTYC250
Display on WebLOCWEBDISPL10
Email AddressLOCEMAILC750
Location/Room ID #LOCIDC120
Location Assignment MessageLOCMESSM100
Location InformationLOCINFOM100
Location MaxLOCMAXN50
Location Assignment MessageLOCMESSM100
Location NotesLOCNOTEM100
Location PhoneLOCPHONEC150
Print Information FlagLOCPRTINL10
Room Record Internal IDLOCRMIDC140
StateLOCSTATEC150
Zip CodeLOCZIPC100

NAMECODE

LabelField NameTypeLengthDecimals
IDNCIDC90
Interest CodeNCCODEC100
IdentifierNCIDENTC10
Add DateNCADDATED80
CourseNCCRSEC120

NAMEDOCS

LabelField NameTypeLengthDecimals
IDNAIDC90
DocumentsNADOCC1000
CommentsNACOMMC750
Date/TimeNATIMED80
CourseNACRSEC120
ValidNAVALIDL10

NAMES

LabelField NameTypeLengthDecimals
ACEweb NoteNMWEBNOTEC700
ACEweb PasswordNMPASSWDC320
ActiveNMDEACTIVEL10
Add DateNMADDATED80
Address Line 1NMADDR1C500
Address Line 2NMADDR2C500
Allowed to Proxy Register Firm on AWNMFMREGl10
AW Bill AmountNMBILLOLN50
Badge/NicknameNMBADGEC200
Bar Code ChecksumNMCHECKSUMC30
Birth dateNMBIRTHD80
Block in ACEwebNMWEBSTOPL10
Call Back DateNMCALLBACKD80
Carrier Route CodeNMCARRTC40
CASS Error CodeNMCASSERRC20
Cell PhoneNMCELLPHC120
CityNMCITYC200
CommentsNMCOMMM100
Contact HistoryNMHISTM100
CountryNMCNTRYC200
CountyNMCOUNTYC150
Created ByNMCREATORC80
Day PhoneNMDPHONEC200
Default Credit TypesNMDEFCRC300
DisabilityNMDISABLEC10
Don’t Mail FlagNMNOMAILL10
Don’t Email FlagNMELISTL10
Dwelling TypeNMHMOWNC20
Educational LevelNMEDLEVELC20
Email AddressNMEMAILC750
Ethnic OriginNMETHNICC20
Family TypeNMFAMTYPEC60
Fax PhoneNMFPHONEC150
Fee CategoryNMFEECATC300
Firm IDNMFMIDC120
Firm NameNMFIRMC750
Firm Reg Level (ACEweb Use)NMREGLVLN10
First NameNMNAME1C300
GroupingNMGROUPIDC90
Home PhoneNMHPHONEC150
Household IncomeNMINCC30
Ignore this name in Mass Combine NamesNMSKIPDUPL10
LanguageNMLANGC20
Last Activity DateNMLASTACTD80
Last NameNMNAME3C450
Line of TravelNMLINOTRVC50
Link FileNMLINKFILEC1000
Mail StopNMMAILSTC100
Marital StatusNMMARSTATC10
Member NumberNMMEMBNUMC140
Middle InitialNMNAME2C120
Miscellaneous Code 1NMCODE1C120
Miscellaneous Code 2NMCODE2C120
Miscellaneous Code 3NMMISCC60
Number of Courses TakenNMNUMTAKN30
Occupational CodeNMOCCC60
Opt InNMSMSOPTL10
Organization CodeNMORGC60
Pager NumberNMPAGERC120
Preferred AddressNMPREFERC10
Preferred Method of ContactNMPMOCC10
Print Label FlagNMPRTLBLL10
Print Label InformationNMLABINFOC180
ProvinceNMPROVINCEC200
Renewed MemberNMRENEWMEML10
Report FlagNMRPTFLAGL10
SalutationNMSALUTC100
Sex (Gender)NMSEXC10
Source CodeNMSOURCEC80
Special NeedsNMSPECM100
IDNMIDC90
SSO IDNMSSOIDM100
StateNMSTATEC20
SuffixNMSUFFC210
TitleNMTITLEC500
Update DateNMUPDATED80
Update TimeNMUPTMC100
Updated ByNMUSERC80
Who should Call BackNMWHOCALLC80
ZipNMZIPC100
Additional Character Field (label specified by organization)NMCHAR1C500

NAMEUDFS

Label UDFs on the UDF screen.

LabelField NameTypeLengthDecimals
IDNUIDC90
User Defined Character 1NUDFC1C200
User Defined Character 2NUDFC2C200
User Defined Character 3NUDFC3C500
User Defined Character 4NUDFC4C500
User Defined Character 5NUDFC5C700
User Defined Date 1NUDFD1D80
User Defined Date 2NUDFD2D80
User Defined Date 3NUDFD3D80
User Defined Date 4NUDFD4D80
User Defined Date 5NUDFD5D80
User Defined Logical 1NUDFL1L10
User Defined Logical 2NUDFL2L10
User Defined Logical 3NUDFL3L10
User Defined Logical 4NUDFL4L10
User Defined Logical 5NUDFL5L10
User Defined Numeric 1NUDFN1N92
User Defined Numeric 2NUDFN2N82
User Defined Numeric 3NUDFN3N82
User Defined Numeric 4NUDFN4N82
User Defined Numeric 5NUDFN5N82

ORGANIZATION DEFAULTS

LabelField NameTypeLengthDecimals
Address Line 1XC_ADDR1C450
Address Line 2XC_ADDR2C450
CityXC_CITYC250
Fax PhoneXC_FPHONEC180
Global Receipt MessageXC_RCPTMESC5000
Organization DepartmentXC_DEPTTITC550
Organization TitleXC_ORGTITLC600
PhoneXC_PHONEC180
StateXC_STATEC20
URLXC_URLC600
Zip CodeXC_ZIPC100
ACEweb URLXS_AWURLC2500

PAY

Label UDFs on the UDF screen.

LabelField NameTypeLengthDecimals
Account CodePYACCOUNTC300
Add TimePYADDTMC100
Address Line 1PYADDR1C500
Address Line 2PYADDR2C500
AmountPYAMTN92
Auth #/Addl InfoPYAUTHNUMC300
CityPYCITYC250
Contact PersonPYCONTC750
Course CodePYCRSEC120
Created ByPYCREATORC80
Credit Card Expiration DatePYEXPRDATEC100
Transaction #PYTRANUMC200
Credit Card, Check, or PO #PYNUMBERC200
DatePYDATED80
Deposit NumberPYACCTFORC120
EmailPYEMAILC750
Escrow ExpirationPYESCEXPD80
Gift Card #PYGIFTC80
Group IDPYPAYIDC120
Pay NotesPYLINKC1250
NamePYNAMEC500
NotePYNOTEC1000
Original ID/CoursePYORIGINALC220
Paid By Taxpayer FlagPYTAXCRL10
Paid To Invoice (Invoice Number)PYINVNUMC80
Payment IDPYSUBIDC120
ACEweb Session IDPYSESSIONC150
Transaction IDPYTRANSIDC450
Phone NumberPYPHONEC200
ProvincePYPROVINCEC200
QuantifierPYQUANTC40
Receipt NumberPYRECNUMC80
IDPYIDC90
StatePYSTATEC20
TypePYTYPEC10
Update DatePYUPDATED80
Update TimePYUPTMC100
Updated ByPYUSERC80
ZipPYZIPC100
User Defined Character 1PYUDFC1C200
User Defined Character 2PYUDFC2C200
User Defined Date 1PYUDFD1D80

REGFEES

LabelField NameTypeLengthDecimals
AmountRFFEEN92
Course CodeRFCRSEC120
Date AddedRFDATED80
Fee DescriptionRFDESCC300
Group IDRFGROUPIDC120
Inventory NumberRFINVNOC80
QuantityRFQUANTN20
IDRFIDC90

REGISTER

LabelField NameTypeLengthDecimals
Add DateRGADDATED80
Add TimeRGADDTIMEC10
Adjustment Amount (No Longer Used)RGADJFEEN92
Adjustment Description (No Longer Used)RGADJDESCC300
Amount (Main)RGCRSEFEEN92
Approved ByRGAPPROVC90
Bill/Pay Only Record FlagRGBILLL10
canceled FlagRGCANCELL10
Certificate Printed DateRGPTCERTD80
CEUSRGCEUSN73
Completed CourseRGCOMPLETED80
Completion Deadline DateRGEXPDATED80
Confirmation DateRGCNFIRMD80
Course CodeRGCRSEC120
Created ByRGCREATORC80
CreditsRGCREDITN41
Fee Description (Main)RGFEEDESCC300
Get Web CertificateRGWEBCERTN10
GradeRGGRADEC30
Group FlagRGGROUPL10
Group IDRGGROUPIDC120
HoursRGHOURSN72
Hybrid StatusRGHYBRIDC10
IdentifierRGIDENTC200
Max UseRGCLASMAXN30
Miscellaneous CodeRGMISCC60
Number of SeatsRGNUMBN40
PartnerRGPARTNERC90
Publish (on ACEweb)?RGPUBLISHL10
QuantifierRGQUANTC40
Registered ByRGPROXYIDC90
Registration CodeRGCODEC60
Registration NoteRGREGNOTEC2500
IDRGIDC90
StatusRGSTATUSC150
Total Paid (No Longer Used) FlagRGTOTALPDL10
Tracking CodeRGTRACKC80
Update DateRGUPDATED80
Update TimeRGUPDTTMC100
Updated ByRGUSERC80
Waitlist FlagRGWAITLISTL10
Who Paid for RegistrationRGWHOPAYC10

REGUDFS

Label UDFs on the UDF screen.

LabelField NameTypeLengthDecimals
Course CodeRUCRSEC120
IDRUIDC90
User Defined Character 1RUDFC1C200
User Defined Character 2RUDFC2C200
User Defined Character 3RUDFC3C200
User Defined Character 4RUDFC4C500
User Defined Date 1RUDFD1D80
User Defined Date 2RUDFD2D80
User Defined Date 3RUDFD3D80
User Defined Date 4RUDFD4D80
User Defined Logical 1RUDFL1L10
User Defined Logical 2RUDFL2L10
User Defined Logical 3RUDFL3L10
User Defined Logical 4RUDFL4L10
User Defined Numeric 1RUDFN1N82
User Defined Numeric 2RUDFN2N82
User Defined Numeric 3RUDFN3N82
User Defined Numeric 4RUDFN4N82

ROOMSPLIT

LabelField NameTypeLengthDecimals
ParentRSPARENTC12
ChildRSCHILDC12

STATES

LabelField NameTypeLengthDecimals
AbbreviationABBREVC20
Full nameFULLNAMEC200

TESTING

LabelField NameTypeLengthDecimals
Add DateTEADDATED8
CodeTECODEC15
CreditsTECREDITSN72
DateTEDATED8
Date2TEDATE2D8
Hide from WebTEHIDEWEBL1
IDTEIDC9
InstitutionTEINSTITUC40
NotesTENOTESC75
ScoreTESCOREC12
TitleTETITLEC75
TypeTETYPEC8
Updated ByTEUSERC8

USER DEFINED LABELS

TabPreferenceLabel NameData Field Name
CourseCochar1xs_coordlabcocoord
CourseCoordinatorxs_cochar1cochar1
Course1 (Instructor Evaluation Fields)xs_lievl1liev1
Course2 (Instructor Evaluation Fields)xs_lievl2liev2
Course3 (Instructor Evaluation Fields)xs_lievl3liev3
Course4 (Instructor Evaluation Fields)xs_lievl4liev4
Course5 (Instructor Evaluation Fields)xs_lievl5liev5
Course6 (Instructor Evaluation Fields)xs_lievl6liev6
Course7 (Instructor Evaluation Fields)xs_lievl7liev7
FacultyCode Labelxs_incode1incode1
FacultyReferen Labelxs_referinreferen
FacultyResume Labelxs_resumeinresume
FirmChar 1xs_fmchar1labfmchar1
FirmChar 2xs_fmchar2labfmchar2
FirmFirm Repxs_replabfmrep
FirmLog 1xs_fmlog1labfmlog1
FirmLog 2xs_fmlog2labfmlog2
FirmSICxs_siclabfmsic
NamesBadge Namexs_badgenmbadge
NamesDisabilityxs_disabilnmdisable
NamesEducation Levelxs_edlevelnmedlevel
NamesEthnic Originxs_ethlabnmethnic
NamesFamily Typexs_famtypenmfamtype
NamesHomeownerxs_homeownnmhmown
NamesHousehold Incomexs_housincnminc
NamesLanguagexs_langlabnmlang
NamesMarital Statusxs_marstatnmmarstat
NamesMember Numberxs_memlabnmmembnum
NamesMiscellaneous Codexs_nmmisclabnmmisc
NamesName Char 1xs_char1labnmchar1
NamesNMCODE1xs_nmcode1nmcode1
NamesNMCODE2xs_nmcode2nmcode2
NamesOccupationxs_occnmocc
NamesOrganizationxs_orgnmorg
NamesPager Phonexs_pagernmpager
Pay(7)xs_paytyp7Payment Type drop down list
Pay(A)xs_paytypaPayment Type drop down list
Pay(B)xs_paytypbPayment Type drop down list
Pay(C)xs_paytypcPayment Type drop down list
Pay(D)xs_paytypdPayment Type drop down list
Pay(E)xs_paytypePayment Type drop down list
Pay(F)xs_paytypfPayment Type drop down list
Pay(G)xs_paytypgPayment Type drop down list
Pay(H)xs_paytyphPayment Type drop down list
RegisterReg Codexs_crgcodergcode
RegisterUse rgptcert (Date Field)xs_certlabrgptcert
RegisterUse rgconfirm (Date Field)xs_conflabrgcnfirm
RegisterUse rgmiscxs_misclabrgmisc

USER PROFILE

LabelField NameTypeLengthDecimals
Full Namem.fullnameC300
User Namem.usermastC80
Email Addressm.usremailC400
Phone Numberm.usrphoneC150
ACEweb Skin Numberxl_awskinN10
Email SignatureemailsigM100
HTML Email SignatureemsightmlM100

WKSHPIND

LabelField NameTypeLengthDecimals
CEUSWICEUSN73
Course CodeWICRSEC120
Date Lesson ReceivedWIRCVDATED80
Date Lesson ReturnedWIRTNDATED80
HoursWIHOURN62
Lesson Faculty IDWIINSTRC120
Lesson GradeWIGRADEC70
Lesson FlagWILESSONL10
QuantifierWIQUANTC40
IDWIIDC90
Test Request DateWITESTREQD80
Workshop CodeWICODEC80

WKSHPMST

LabelField NameTypeLengthDecimals
AmountWMFEEAMTN82
CEUSWMCEUSN73
Course CodeWMCRSEC120
DateWMDATED80
Do Not Display on ACEwebWMWEBHIDEL10
Enrollment CountWMENROLLN50
Fee DescriptionWMFEEDESCC300
HoursWMHOURN62
LeaderWMLEADERC500
LocationWMLOCC200
Maximum SizeWMMAXN40
NoteWMNOTEC1200
Option 1WMOPT1C150
Option 2WMOPT2C150
TimesWMTIMEC200
TitleWMTITLEC950
Workshop CodeWMCODEC80
Workshop Description CodeWMCATCODEC100

ZIP

LabelField NameTypeLengthDecimals
Area CodeZIPAREAC30
CityZIPCITYC200
CountryZIPCNTRYC200
CountyZIPCOUNTYC150
RegionZIPREGIONC30
StateZIPSTATEC20
ZipZIPZIPC100