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 (Attendance Tracking)
| LABEL | FIELD NAME | TYPE | LENGTH | |
|
Attendance Code |
ATCODE |
C |
6 |
0 |
|
Course Code |
ATCRSE |
C |
12 |
0 |
|
Grade |
ATGRADE |
C |
3 |
0 |
|
ID |
ATID |
C |
9 |
0 |
| Module | ATMODULE | C | 12 | 0 |
| Name | ATNAME | C | 75 | 0 |
|
Session Date |
ATDATE |
D |
8 |
0 |
|
Session Hours |
ATHOURS |
N |
4 |
2 |
BUDGET
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Course Code |
BUCRSE |
C |
12 |
0 |
|
Estimated Enrollment for Fee |
BUFEENUM |
N |
4 |
0 |
|
Fee Amount |
BUFEEAMT |
N |
9 |
0 |
|
Fee LABEL |
BUFEEDESC |
C |
25 |
0 |
|
Fee Type |
BUFEETYPE |
C |
1 |
0 |
CATALOG
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Active | CAACTIVE | L | 1 | 0 |
|
Add Date |
CAADDATE |
D |
8 |
0 |
|
Audience |
CAAUDIENCE |
M |
10 |
0 |
| Begin Date | CABEGDATE | D | 8 | 0 |
| Begin Time | CABEGTIME | C | 5 | 0 |
|
Benefits |
CABENEFITS |
M |
10 |
0 |
| Bio/Credentials | CABIO | M | 10 | 0 |
|
Code |
CACODE |
C |
10 |
0 |
|
Contact Email |
CACEMAIL |
C |
50 |
0 |
|
Contact Name |
CACNAME |
C |
50 |
0 |
|
Contact Phone |
CACPHONE |
C |
20 |
0 |
|
Web Address |
CAWEBADDR |
C |
75 |
0 |
|
Created By |
CACREATOR |
C |
8 |
0 |
| End Time | CAENDTIME | C | 5 | 0 |
|
Fee |
CAPROPFEE |
N |
8 |
2 |
|
Features |
CAFEATURES |
M |
10 |
0 |
| Graphic | CAPIC | C | 75 | 0 |
| Hours | CAHOURS | N | 7 | 2 |
| Instructor Expenses | CAINEXP | M | 10 | 0 |
|
Kind |
CAKIND |
C |
1 |
0 |
| Location | CALOC | C | 40 | 0 |
|
Materials |
CAMATERIAL |
M |
10 |
0 |
|
Name |
CANAME |
C |
95 |
0 |
|
Optional 1 |
CAOPT1 |
C |
95 |
0 |
|
Optional 2 |
CAOPT2 |
C |
95 |
0 |
|
Prerequisite Description |
CAPREREQ |
M |
10 |
0 |
|
Primary Description |
CADESC |
M |
10 |
0 |
|
Publish on Web? |
CAPUBLISH |
L |
1 |
0 |
|
Schedule |
CASCHEDULE |
C |
60 |
0 |
|
Secondary Description (Web) |
CADESC2 |
M |
10 |
0 |
| # of Sessions | CASESS | N | 3 | 0 |
|
Status |
CASTATUS |
C |
10 |
0 |
|
Subject Code |
CASUBJ |
C |
8 |
0 |
|
Text Book |
CATEXT |
C |
100 |
0 |
| Thumbnail | CATHUMB | M | 10 | 0 |
|
Updated By |
CAUSER |
C |
8 |
0 |
| Update Date | CAUPDATE | D | 8 | 0 |
CATGROUP
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Catalog Code |
CGCATALOG |
C |
12 |
0 |
|
Grouping Code |
CGCODE |
C |
6 |
0 |
CHOICES
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Active Code? |
CHACTIVE |
L |
1 |
0 |
|
Choice |
CHOICE |
C |
15 |
0 |
|
Cost of Promotion |
COST |
N |
6 |
0 |
| Creator | CREATOR | C | 8 | 0 |
| Description |
DISCRIPT |
C |
50 |
0 |
| Detail |
CHMEMO |
M |
10 |
0 |
|
Identifier |
IDENTIFIER |
C |
30 |
0 |
| Major Expense Category |
TIMEUPDATE |
C |
8 |
0 |
|
Number of Brochures |
NO_BROCH |
N |
6 |
0 |
|
Order Point |
ORDERPT |
N |
4 |
0 |
|
Promotion Date |
DATEUPDATE |
D |
8 |
0 |
| Scope By | INTIDENT | C | 1 | 0 |
|
Show/Hide from Web |
MARKED |
L |
1 |
0 |
|
Specific Course/File Name for Image |
CRSE |
C |
12 |
0 |
| Updated | UPDATE | D | 8 | 0 |
| User | USER | C | 8 | 0 |
COURSE
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Account Code |
COACCOUNT |
C |
30 |
0 |
|
ACEweb Publish Properties |
COWEBREG |
N |
1 |
0 |
|
Active Flag |
COACTIVE |
L |
1 |
0 |
|
Add Date |
COADDATE |
D |
8 |
0 |
| Age Requirement | COAGEREQ | N | 2 | 0 |
|
Allow Web Waitlist |
COWEBWAIT |
L |
1 |
0 |
|
Alternate Display Course Code |
COALIAS |
C |
32 |
0 |
| Attachment (email receipt) |
CORECATT |
C |
250 |
0 |
|
Begin Date |
COBEGDATE |
D |
8 |
0 |
|
Budget Add Date |
COBUADD |
D |
8 |
0 |
|
Budget Breakeven |
COBUBREAK |
N |
5 |
0 |
|
Budget Go No-Go |
COBUNOGO |
N |
5 |
0 |
|
Budget Notes |
COBUNOTE |
C |
100 |
0 |
|
Budget Overhead |
COBUOVER |
N |
2 |
0 |
| Budget Profit Share | COBUSHARE | N | 2 | 0 |
|
Budget Updated |
COBUUPDATE |
D |
8 |
0 |
|
Budget User |
COBUUSER |
C |
8 |
0 |
|
Canceled Flag |
COCANCEL |
L |
1 |
0 |
|
Catalog Code |
COCATCODE |
C |
10 |
0 |
|
Category |
COCATEGORY |
C |
12 |
0 |
|
CEUS |
COCEUS |
N |
7 |
3 |
|
Comments (Reminder Note) |
CONOTENPRT |
M |
10 |
0 |
|
Coordinator |
COCOORD |
C |
20 |
0 |
|
Course Code |
COCRSE |
C |
12 |
0 |
|
Course Time |
COCRSETM |
C |
85 |
0 |
| Created By | COCREATOR | C | 8 | 0 |
|
Credits |
COCREDIT |
N |
4 |
1 |
|
Date Opened for Enrollment |
COOPENDAT |
D |
8 |
0 |
|
Days of Week |
CODOW |
C |
7 |
0 |
|
Department |
CODEPT |
C |
35 |
0 |
| Email Reminders to Students | COEREMFL | L | 1 | 0 |
| Email Reminders Datetime | COREMDT | D | 8 | 0 |
|
End Date |
COENDDATE |
D |
8 |
0 |
|
End Hours |
COENDHRS |
N |
2 |
0 |
|
End Minutes |
COENDMIN |
N |
2 |
0 |
|
Enrollment Count |
COENROLLED |
N |
5 |
0 |
|
Estimated Enrollment |
COESTENRL |
N |
4 |
0 |
| Gift Exp Date | COGIFTEXPD | D | 8 | 0 |
| Gift Exp Days | COGIFTEXPN | N | 4 | 0 |
|
Group Count |
COGRPCT |
N |
5 |
0 |
|
Hours |
COHOURS |
N |
7 |
2 |
|
Instructor ID (No longer in use) |
COINSTID |
C |
12 |
0 |
|
Lag Days for ACEweb |
COWEBLAG |
N |
3 |
0 |
| Lag Days for Billing on ACEweb | COBILLAG | N | 3 | 0 |
|
Location ID |
COLOCID |
C |
12 |
0 |
|
Locked Flag |
COLOCKED |
L |
1 |
0 |
|
Maximum Size |
COMAX |
N |
5 |
0 |
| Membership Requisites | COMEMREQ | C | 100 | 0 |
| Merchant Number | COMERCNUM | C | 15 | 0 |
|
Minimum Size |
COMIN |
N |
3 |
0 |
|
Months to Complete |
COEXPTIME |
N |
2 |
0 |
| Must Logon to View (Express) | COLOGFIRST | L | 1 | 0 |
|
New Course Flag |
CONEW |
L |
1 |
0 |
|
Note (Printed on Receipt) |
CONOTEPRT |
M |
10 |
0 |
| Online Course Provider | COSERVICE | C | 3 | 0 |
| Online Note | CONOTEONL | M | 10 | 0 |
|
Persons to Notify Via ACEweb |
CONOTIFY |
C |
150 |
0 |
| Physical Max | COPHYSMAX | N | 3 | 0 |
|
Print Location Flag |
COLOCPRTIN |
L |
1 |
0 |
| Publish Date | COPUBDATE | D | 8 | 0 |
| Proxy Type | COPROXYTYP | C | 10 | 0 |
|
Qualifies for Tax Credit Flag |
COTAXCR |
L |
1 |
0 |
|
Reason Course was Canceled |
COWHYCX |
C |
50 |
0 |
| Receipt Template | CORECCODE | C | 10 | 0 |
|
Reference Document |
COREFDOC |
C |
100 |
0 |
|
Registration Time |
COREGTIME |
C |
80 |
0 |
|
Registration Warning Message |
COREGWARN |
C |
80 |
0 |
|
Registrant Information Shown on ACEweb Rosters |
COLISTCLAS |
M |
10 |
0 |
|
Remind When |
COREMWHEN |
D |
8 |
0 |
|
Remind Who |
COREMWHO |
C |
8 |
0 |
|
Sessions Number |
COSESS |
N |
3 |
0 |
|
Short Title |
COSHORTNM |
C |
30 |
0 |
| Show on Web Transcript | COWEBTRAN | N | 1 | 0 |
|
Settings for ACEweb Special Functions |
COWEBCFG |
M |
10 |
0 |
|
Special ACEweb Data Capture Page |
COWEBCARD |
C |
20 |
0 |
|
Special ACEweb Information Page |
COWEBSTAT |
C |
20 |
0 |
|
Sponsoring Firm |
COFMID |
C |
12 |
0 |
|
Start Hour |
COSTHRS |
N |
2 |
0 |
|
Start Minute |
COSTMIN |
N |
2 |
0 |
|
Subject Code |
COSUBCODE |
C |
8 |
0 |
|
Title |
COCRSENM |
C |
125 |
0 |
|
Track Attendance |
COTRKATT |
L |
1 |
0 |
|
Type |
COTYPE |
C |
12 |
0 |
|
Update Date |
COUPDATE |
D |
8 |
0 |
|
Update Time |
COUPTM |
C |
10 |
0 |
|
Updated By |
COUSER |
C |
8 |
0 |
| URL | COURL | C | 250 | 0 |
|
Waitlist Count |
COWAITNUM |
N |
5 |
0 |
| Web Certificate | COWEBCERT | C | 50 | 0 |
|
Web Grade Book Access Level |
COWEBGRADE |
N |
1 |
0 |
|
Web Workshop Message |
COWEBWKMSG |
M |
10 |
0 |
|
Workshop Enabled (No Longer Used) |
COWKSHOP |
L |
1 |
0 |
|
Workshop Maximum |
COWKMAX |
N |
2 |
0 |
|
Workshop Minimum |
COWKMIN |
N |
2 |
0 |
|
Additional Character Field (label specified by organization) |
COCHAR1 |
C |
15 |
0 |
CREDINDV
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Course Code |
CICRSE |
C |
12 |
0 |
|
Credit Code |
CICODE |
C |
8 |
0 |
|
ID |
CIID |
C |
9 |
0 |
|
Note |
CINOTE |
C |
30 |
0 |
|
Type |
CITYPE |
C |
6 |
0 |
|
Units |
CIUNIT |
N |
6 |
2 |
CREDMAST
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Course Code |
CMCRSE |
C |
12 |
0 |
|
Type |
CMTYPE |
C |
6 |
0 |
|
Units |
CMUNIT |
N |
6 |
2 |
|
Credit Code |
CMCODE |
C |
8 |
0 |
|
Note |
CMNOTE |
C |
30 |
0 |
CRM (Customer Relationship Management)
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Course | CRCRSE | C | 12 | 0 |
|
Date |
CRDATE |
D |
8 |
0 |
|
ID |
CRID |
C |
9 |
0 |
|
Subject |
CRSUBJECT |
C |
60 |
0 |
|
Type |
CRTYPE |
C |
1 |
0 |
|
User |
CRUSER |
C |
8 |
0 |
CRSEREM
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Course Code | REMCRSE | C | 12 |
0 |
| Remind Who? | REMWHO | C | 8 |
0 |
| When? | REMWHEN | D | 8 |
0 |
| Reminder Note | REMNOTES | M | 10 |
0 |
| OID | REMOID | C | 12 |
0 |
CRSEUDFS
Descriptions for the User Defined Fields are set by your organization. Labels are assigned from Edit > Preferences > Course tab > Course UDF's button.
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Course Code |
CUCRSE |
C |
12 |
0 |
|
User defined Character 1 |
CUDFC1 |
C |
35 |
0 |
|
User defined Character 2 |
CUDFC2 |
C |
35 |
0 |
|
User defined Character 3 |
CUDFC3 |
C |
50 |
0 |
|
User defined Character 4 |
CUDFC4 |
C |
70 |
0 |
|
User defined Date 1 |
CUDFD1 |
D |
8 |
0 |
|
User defined Date 2 |
CUDFD2 |
D |
8 |
0 |
|
User defined Date 3 |
CUDFD3 |
D |
8 |
0 |
|
User defined Date 4 |
CUDFD4 |
D |
8 |
0 |
|
User defined Logical 1 |
CUDFL1 |
L |
1 |
0 |
|
User defined Logical 2 |
CUDFL2 |
L |
1 |
0 |
|
User defined Logical 3 |
CUDFL3 |
L |
1 |
0 |
|
User defined Logical 4 |
CUDFL4 |
L |
1 |
0 |
|
User defined Numeric 1 |
CUDFN1 |
N |
8 |
2 |
|
User defined Numeric 2 |
CUDFN2 |
N |
8 |
2 |
|
User defined Numeric 3 |
CUDFN3 |
N |
8 |
2 |
|
User defined Numeric 4 |
CUDFN4 |
N |
8 |
2 |
| Course Specific Character 1 Registration Label | CULBLC1 | C | 15 | 0 |
| Course Specific Character 2 Registration Label | CULBLC2 | C | 15 | 0 |
| Course Specific Character 3 Registration Label | CULBLC3 | C | 15 | 0 |
| Course Specific Character 4 Registration Label | CULBLC4 | C | 15 | 0 |
| Course Specific Date 1 Registration Label | CULBLD1 | C | 15 | 0 |
| Course Specific Date 2 Registration Label | CULBLD2 | C | 15 | 0 |
| Course Specific Date 3 Registration Label | CULBLD3 | C | 15 | 0 |
| Course Specific Date 4 Registration Label | CULBLD4 | C | 15 | 0 |
| Course Specific Logical 1 Registration Label | CULBLL1 | C | 15 | 0 |
| Course Specific Logical 2 Registration Label | CULBLL2 | C | 15 | 0 |
| Course Specific Logical 3 Registration Label | CULBLL3 | C | 15 | 0 |
| Course Specific Logical 4 Registration Label | CULBLL4 | C | 15 | 0 |
| Course Specific Numeric 1 Registration Label | CULBLN1 | C | 15 | 0 |
| Course Specific Numeric 2 Registration Label | CULBLN2 | C | 15 | 0 |
| Course Specific Numeric 3 Registration Label | CULBLN3 | C | 15 | 0 |
| Course Specific Numeric 4 Registration Label | CULBLN4 | C | 15 | 0 |
CRSROOM (Room Use)
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Add Date | CRMADDDATE | D | 8 | 0 |
|
Course Code |
CRMCRSE |
C |
12 |
0 |
| Created By | CRMCREATOR | C | 8 | 0 |
|
Date |
CRMDATE |
D |
8 |
0 |
|
End Hours |
CRMENDHRS |
N |
2 |
0 |
|
End Minutes |
CRMENDMIN |
N |
2 |
0 |
|
Location ID |
CRMLOCID |
C |
12 |
0 |
|
Start Hours |
CRMSTHRS |
N |
2 |
0 |
|
Start Minutes |
CRMSTMIN |
N |
2 |
0 |
|
Time |
CRMTM |
C |
30 |
0 |
| Updated | CRMUPDATE | D | 8 | 0 |
| Updated By | CRMUSER | C | 8 | 0 |
FEES
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Amount |
FEFEE |
N |
9 |
2 |
|
Coupon/Inventory Code |
FEINVNO |
C |
8 |
0 |
|
Course Code |
FECRSE |
C |
12 |
0 |
|
Expires (days) |
FEEXP |
N |
4 |
0 |
|
Fee Description |
FEDESC |
C |
50 |
0 |
|
Hide from Web Flag |
FEWEBHIDE |
L |
1 |
0 |
| Hybrid | FEHYBRID | C | 1 | 0 |
|
Mandatory Flag |
FEAUTO |
L |
1 |
0 |
|
Order |
FEORDER |
N |
2 |
0 |
|
Type |
FEIDENT |
C |
1 |
0 |
| Max | FEMAX | N | 4 | 0 |
| Member Expires (Date) | FETERMDATE | D | 8 | 0 |
| Member Expires (# of Days) | FETERMOFF | N | 5 | 0 |
| Member Code | FEMEMCODE | C | 10 | 0 |
FINAIDI
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Add Date | FAIADDATE | D | 8 | |
| Amount Expected | FAIEXPECT | N | 8 | 2 |
| Date Expected | FAIEXPECTD | D | 8 | |
| Course Applied | FAICRSE | C | 12 | |
| ID (Name) | FAIID | C | 9 | |
| Notes | FAINOTE | C | 100 | |
| Received | FAIRECEIVE | N | 8 | 2 |
| Updated By | FAIUSER | C | 8 | |
| Update Date | FAIUPDATE | D | 8 | |
FINAIDM
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Award Date | FAMAWARDED | D | 8 | |
| Date Added | FAMADDATE | D | 8 | |
| EFC | FAMEFC | N | 8 | 2 |
| ID (Name) | FAMID | C | 9 | |
| Payment Type | FAMPYTYPE | C | 1 | |
| Returned | FAMRETURN | 1 | 8 | 2 |
| Total Expected | FAMTOTAL | N | 8 | 2 |
| Type | FAMTYPE | C | 30 | |
| Updated | FAMUPDATE | D | 8 | |
| Updated By | FAMUSER | C | 8 | |
FIRM
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
# of Employees |
FMEMPLOY |
N |
5 |
0 |
|
$ Credits |
FMCREDITS |
N |
9 |
2 |
|
Add Date |
FMADDATE |
D |
8 |
0 |
|
Additional Information |
FMEXTRA |
C |
65 |
0 |
|
Address Line 1 |
FMADDR1 |
C |
50 |
0 |
|
Address Line 2 |
FMADDR2 |
C |
50 |
0 |
|
Bill Address Line 1 |
FMBADDR1 |
C |
50 |
0 |
|
Bill Address Line 2 |
FMBADDR2 |
C |
50 |
0 |
|
Bill City |
FMBCITY |
C |
17 |
0 |
|
Bill Country |
FMBCNTRY |
C |
20 |
0 |
|
Bill Phone |
FMBPHONE |
C |
15 |
0 |
|
Bill State |
FMBSTATE |
C |
2 |
0 |
|
Bill to Attention of |
FMBATTN |
C |
30 |
0 |
|
Bill Zip |
FMBZIP |
C |
10 |
0 |
|
City |
FMCITY |
C |
17 |
0 |
|
Comments |
FMCOMM |
M |
10 |
0 |
|
Contact |
FMCONTACT |
C |
75 |
0 |
|
Contact 2 |
FMCONTACT2 |
C |
75 |
0 |
| County | FMCOUNTY | C | 15 | 0 |
|
Country |
FMCNTRY |
C |
20 |
0 |
|
|
FMEMAIL |
C |
60 |
0 |
|
Email 2 |
FMEMAIL2 |
C |
60 |
0 |
|
Fax Phone |
FMFPHONE |
C |
15 |
0 |
|
Federal ID |
FMFEDID |
C |
12 |
0 |
| Fee Category | FMFEECAT | C | 30 | 0 |
| Firm Name | FMFIRM | C | 75 | 0 |
|
Firm ID |
FMID |
C |
12 |
0 |
|
Firm Representative |
FMREP |
C |
6 |
0 |
| Link File | FMLINKFILE | C | 50 | 0 |
|
Org Code |
FMORG |
C |
6 |
0 |
|
Parent Company |
FMCORP |
C |
35 |
0 |
|
Phone |
FMPHONE |
C |
15 |
0 |
|
Province |
FMPROVINCE |
C |
20 |
0 |
|
Qualification Code |
FMQUALIFY |
C |
2 |
0 |
|
SIC |
FMSIC |
C |
9 |
0 |
|
Size (in $000’s) |
FMSIZE |
N |
7 |
0 |
|
State |
FMSTATE |
C |
2 |
0 |
|
Type |
FMIDENT |
C |
1 |
0 |
|
Update Date |
FMUPDATE |
D |
8 |
0 |
|
URL |
FMURL |
C |
75 |
0 |
|
User |
FMUSER |
C |
8 |
0 |
|
Zip |
FMZIP |
C |
10 |
0 |
|
Firm Character Field 1 (label specified by organization) |
FMCHAR1 |
C |
12 |
0 |
|
Firm Character Field 2 (label specified by organization) |
FMCHAR2 |
C |
12 |
0 |
|
Firm Logical Field 1 (label specified by organization) |
FMLOG1 |
L |
1 |
0 |
|
Firm Logical Field 2 (label specified by organization) |
FMLOG2 |
L |
1 |
0 |
GIFTCARD
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Number |
GCNUM |
C |
8 |
0 |
|
Sub ID |
GCSUBID |
C |
12 |
0 |
| Used | GCUSED | L | 1 | 0 |
| Notes | GCNOTES | M | 10 | 0 |
| Name ID | GCID | C | 9 | 0 |
| Expiration Date | GCEXPIRE | D | 8 | 0 |
GROUPING
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Course Code |
GRCRSE |
C |
12 |
0 |
|
Grouping Code |
GRCODE |
C |
6 |
0 |
HOLIDAYS
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Date |
DATE |
D |
8 |
0 |
|
Description |
DESCRIPT |
C |
30 |
0 |
|
Local Holiday |
LOC_HOL |
C |
40 |
0 |
INSTRUCT
Descriptions for the User Defined Fields are set by your organization. Labels are assigned from Edit > Preferences > Faculty tab > Instruct UDF's button.
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
ACEweb Edit Level |
INLEVEL |
N |
1 |
0 |
|
Active Flag |
INPRTLBL |
L |
1 |
0 |
|
Add Date |
INADDATE |
D |
8 |
0 |
|
Address Line 1 |
INADDR1 |
C |
50 |
0 |
|
Address Line 2 |
INADDR2 |
C |
50 |
0 |
|
Available Friday Flag |
INAVLFRI |
L |
1 |
0 |
|
Available Monday Flag |
INAVLMON |
L |
1 |
0 |
|
Available Saturday Flag |
INAVLSAT |
L |
1 |
0 |
|
Available Sunday Flag |
INAVLSUN |
L |
1 |
0 |
|
Available Thursday Flag |
INAVLTHU |
L |
1 |
0 |
|
Available Tuesday Flag |
INAVLTUE |
L |
1 |
0 |
|
Available Wednesday Flag |
INAVLWED |
L |
1 |
0 |
|
Bio |
INBIO |
M |
10 |
0 |
|
Call Back Date |
INCALLBACK |
D |
8 |
0 |
|
Cell Phone |
INCELLPH |
C |
15 |
0 |
|
City |
INCITY |
C |
17 |
0 |
|
Code 1 |
INCODE1 |
C |
12 |
0 |
|
Comments |
INCOMM |
M |
10 |
0 |
|
Country |
INCNTRY |
C |
20 |
0 |
|
Day Phone |
INDPHONE |
C |
15 |
0 |
|
Email Address |
INEMAIL |
C |
60 |
0 |
|
Employment Status |
INUDFN1 |
N |
8 |
2 |
|
Evaluation Notes |
INEVALNOTE |
M |
10 |
0 |
|
Faculty System ID |
INSTID |
C |
12 |
0 |
|
Fax Phone |
INFPHONE |
C |
15 |
0 |
|
Firm ID |
INFMID |
C |
12 |
0 |
|
Firm |
INFIRM |
C |
75 |
0 |
|
First Name |
INNAME1 |
C |
15 |
0 |
|
Give out Day Phone Flag |
INGIVEDPHO |
L |
1 |
0 |
|
Give out Email Flag |
INGIVEEM |
L |
1 |
0 |
|
Give out Home Phone Flag |
INGIVEHPHO |
L |
1 |
0 |
| Give out Cell Phone Flag | INGIVECELL | L | 1 | 0 |
|
Home Phone |
INHPHONE |
C |
14 |
0 |
|
HTML |
INHTML |
M |
10 |
0 |
|
ID # |
INID |
C |
9 |
0 |
|
ID/FEIN |
INSSN |
C |
11 |
0 |
|
Last Name |
INNAME3 |
C |
30 |
0 |
|
Middle Name |
INNAME2 |
C |
12 |
0 |
|
Occupation Code |
INOCC |
C |
6 |
0 |
|
Organization Code |
INORG |
C |
6 |
0 |
|
Pager Number |
INPAGER |
C |
15 |
0 |
|
Payment Notes |
INPAYNOTE |
M |
10 |
0 |
|
Prefer M of C |
INPMOC |
C |
1 |
0 |
|
Print Label Flag |
INLABEL |
L |
1 |
0 |
|
Province |
INPROVINCE |
C |
20 |
0 |
|
Reference Document |
INREFEREN |
C |
100 |
0 |
|
Resume |
INRESUME |
C |
100 |
0 |
|
Salutation |
INSALUT |
C |
4 |
0 |
|
Schedule Exceptions |
INSCHEDULE |
C |
70 |
0 |
|
Skills |
INSKILL |
C |
100 |
0 |
|
Source Code |
INSOURCE |
C |
6 |
0 |
|
Staff Contact |
INHANDLER |
C |
15 |
0 |
|
State |
INSTATE |
C |
2 |
0 |
|
Suffix |
INSUFF |
C |
10 |
0 |
|
Title |
INTITLE |
C |
50 |
0 |
|
Update Date |
INUPDATE |
D |
8 |
0 |
|
User |
INUSER |
C |
8 |
0 |
|
User Defined Character 1 (Pay Type) |
INUDFC1 |
C |
20 |
0 |
|
User Defined Character 2 |
INUDFC2 |
C |
20 |
0 |
|
User Defined Character 3 |
INUDFC3 |
C |
20 |
0 |
|
User Defined Character 4 |
INUDFC4 |
C |
60 |
0 |
|
User Defined Date 1 |
INUDFD1 |
D |
8 |
0 |
|
User Defined Date 2 |
INUDFD2 |
D |
8 |
0 |
|
User Defined Date 3 |
INUDFD3 |
D |
8 |
0 |
|
User Defined Date 4 |
INUDFD4 |
D |
8 |
0 |
|
User Defined Logical 1 |
INUDFL1 |
L |
1 |
0 |
|
User Defined Logical 2 |
INUDFL2 |
L |
1 |
0 |
|
User Defined Logical 3 |
INUDFL3 |
L |
1 |
0 |
|
User Defined Logical 4 |
INUDFL4 |
L |
1 |
0 |
|
User Defined Numeric 2 |
INUDFN2 |
N |
8 |
2 |
|
User Defined Numeric 3 |
INUDFN3 |
N |
8 |
2 |
|
User Defined Numeric 4 |
INUDFN4 |
N |
8 |
2 |
|
View Student Email (on ACEweb)? |
INSHOWEM |
L |
1 |
0 |
|
Who Should Call Back |
INWHOCALL |
C |
8 |
0 |
|
Zip |
INZIP |
C |
10 |
0 |
LEDGDESC
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Cost Center Code |
LDCODE |
C |
12 |
0 |
|
Cost Center Description |
LDDESC |
C |
55 |
0 |
LEDGENTR
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Account Code |
LEACCTNUM |
C |
30 |
0 |
|
Amount |
LEAMT |
N |
10 |
2 |
|
Budget Expense Type |
LETYPE |
C |
1 |
0 |
|
Budget Record ID |
LEBUOID |
C |
10 |
0 |
|
Cost Center Code |
LECODE |
C |
12 |
0 |
|
Date of Expense |
LEDATE |
D |
8 |
0 |
|
Date Posted |
LEPOSTDATE |
D |
8 |
0 |
|
Description |
LEDESC |
C |
125 |
0 |
|
Expense Classification |
LECLASS |
C |
6 |
0 |
|
Expense or Income Flag |
LEEXP_INC |
L |
1 |
0 |
|
Group ID |
LEGROUPID |
C |
12 |
0 |
|
Item Received Flag |
LERCVD |
L |
1 |
0 |
|
Major Expense Category |
LECAT |
C |
2 |
0 |
|
Other Detail |
LEDETAIL |
C |
20 |
0 |
|
Paid Flag |
LEPAID |
L |
1 |
0 |
|
PO Number |
LEPONUM |
C |
10 |
0 |
|
Projected or Actual Flag |
LEPROJ |
L |
1 |
0 |
|
Quantity |
LEQTY |
N |
5 |
0 |
|
Receipt # |
LERECNUM |
C |
12 |
0 |
|
User |
LEUSER |
C |
8 |
0 |
|
Vendor ID |
LEVENID |
C |
12 |
0 |
|
Vendor Name |
LEVENDNM |
C |
75 |
0 |
LINKINST
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
# of Class Sessions |
LISESS |
N |
3 |
0 |
|
Account Code |
LIACCOUNT |
C |
30 |
0 |
|
Amount to deduct from Gross or Net pay |
LIPYDEDUCT |
N |
9 |
2 |
|
Comments |
LICOMM |
C |
60 |
0 |
|
Course Code |
LICRSE |
C |
12 |
0 |
|
Date Paid |
LIDATEPAID |
D |
8 |
0 |
|
Evaluation Criteria 1 |
LIEV1 |
N |
3 |
0 |
|
Evaluation Criteria 2 |
LIEV2 |
N |
3 |
0 |
|
Evaluation Criteria 3 |
LIEV3 |
N |
3 |
0 |
|
Evaluation Criteria 4 |
LIEV4 |
N |
3 |
0 |
|
Evaluation Criteria 5 |
LIEV5 |
N |
3 |
0 |
|
Evaluation Criteria 6 |
LIEV6 |
N |
3 |
0 |
|
Evaluation Criteria 7 |
LIEV6 |
N |
3 |
0 |
|
Expense Classification |
LICLASS |
C |
6 |
0 |
|
Faculty member Flag (No Longer Used) |
LIFACULTY |
L |
1 |
0 |
|
Group ID |
LIGROUPID |
C |
12 |
0 |
|
Hours teaching |
LIHOURS |
N |
7 |
2 |
|
Instructor ID |
LIINSTID |
C |
12 |
0 |
|
Miscellaneous Pay Description |
LIMISCDESC |
C |
30 |
0 |
|
Miscellaneous Payment |
LIMISCPAY |
N |
7 |
2 |
|
Pay Notes |
LIPAYNOTE |
C |
250 |
0 |
|
Payment Date |
LIPAYDATE |
D |
8 |
0 |
|
Payment Rate |
LIPAYRATE |
N |
8 |
2 |
|
Payment Type |
LIPAYTYPE |
C |
1 |
0 |
|
Percent of Class |
LIPERCENT |
N |
6 |
2 |
|
Presentation Date |
LIPRESDATE |
D |
8 |
0 |
|
Presentation Time |
LIPRESTIME |
C |
85 |
0 |
|
Presentation Title |
LIPRESTITL |
C |
95 |
0 |
|
Presentation Type |
LIPRESTYPE |
C |
17 |
0 |
|
Presentation Venue |
LIPRESVENU |
C |
40 |
0 |
|
Ref (%age) |
LIPAYREF |
N |
7 |
0 |
|
User |
LIUSER |
C |
8 |
0 |
LOCATION
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Active |
LOCACTIVE |
L |
1 |
0 |
|
Additional (ACEweb) Information |
LOCHTML |
M |
10 |
0 |
| Address Line 1 | LOCADDR1 | C | 36 | 0 |
| Address Line 2 | LOCADDR2 | C | 30 | 0 |
| Building/Room | LOCLOCAT | C | 55 | 0 |
| Campus | LOCCAMPUS | C | 30 | 0 |
| Character 1 | LOCUDF1 | C | 50 | 0 |
| Character 2 | LOCUDF2 | C | 90 | 0 |
|
City |
LOCCITY |
C |
20 |
0 |
| Contact | LOCCONTACT | C | 50 | 0 |
|
County |
LOCCOUNTY |
C |
25 |
0 |
|
Display on Web |
LOCWEBDISP |
L |
1 |
0 |
| Email Address | LOCEMAIL | C | 75 | 0 |
|
Location/Room ID # |
LOCID |
C |
12 |
0 |
| Location Assignment Message | LOCMESS | M | 10 | 0 |
|
Location Information |
LOCINFO |
M |
10 |
0 |
| Location Max | LOCMAX | N | 5 | 0 |
| Location Assignment Message | LOCMESS | M | 10 | 0 |
|
Location Notes |
LOCNOTE |
M |
10 |
0 |
| Location Phone | LOCPHONE | C | 15 | 0 |
|
Print Information Flag |
LOCPRTIN |
L |
1 |
0 |
|
Room Record Internal ID |
LOCRMID |
C |
14 |
0 |
|
State |
LOCSTATE |
C |
15 |
0 |
| Zip Code | LOCZIP | C | 10 | 0 |
NAMECODE
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
ID |
NCID |
C |
9 |
0 |
|
Interest Code |
NCCODE |
C |
10 |
0 |
|
Identifier |
NCIDENT |
C |
1 |
0 |
|
Add Date |
NCADDATE |
D |
8 |
0 |
| Course | NCCRSE | C | 12 | 0 |
NAMEDOCS
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
ID |
NAID |
C |
9 |
0 |
|
Documents |
NADOC |
C |
100 |
0 |
|
Comments |
NACOMM |
C |
75 |
0 |
| Date/Time | NATIME | D | 8 | 0 |
| Course | NACRSE | C | 12 | 0 |
| Valid | NAVALID | L | 1 | 0 |
NAMES
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
ACEweb Note |
NMWEBNOTE |
C |
70 |
0 |
|
ACEweb Password |
NMPASSWD |
C |
32 |
0 |
| Active | NMDEACTIVE | L | 1 | 0 |
|
Add Date |
NMADDATE |
D |
8 |
0 |
|
Address Line 1 |
NMADDR1 |
C |
50 |
0 |
|
Address Line 2 |
NMADDR2 |
C |
50 |
0 |
| Allowed to Proxy Register Firm on AW | NMFMREG | l | 1 | 0 |
| AW Bill Amount | NMBILLOL | N | 5 | 0 |
|
Badge/Nickname |
NMBADGE |
C |
20 |
0 |
|
Bar Code Checksum |
NMCHECKSUM |
C |
3 |
0 |
|
Birth date |
NMBIRTH |
D |
8 |
0 |
|
Block in ACEweb |
NMWEBSTOP |
L |
1 |
0 |
|
Call Back Date |
NMCALLBACK |
D |
8 |
0 |
|
Carrier Route Code |
NMCARRT |
C |
4 |
0 |
|
CASS Error Code |
NMCASSERR |
C |
2 |
0 |
|
Cell Phone |
NMCELLPH |
C |
12 |
0 |
|
City |
NMCITY |
C |
20 |
0 |
|
Comments |
NMCOMM |
M |
10 |
0 |
|
Contact History |
NMHIST |
M |
10 |
0 |
|
Country |
NMCNTRY |
C |
20 |
0 |
|
County |
NMCOUNTY |
C |
15 |
0 |
|
Created By |
NMCREATOR |
C |
8 |
0 |
|
Day Phone |
NMDPHONE |
C |
20 |
0 |
|
Default Credit Types |
NMDEFCR |
C |
30 |
0 |
|
Disability |
NMDISABLE |
C |
1 |
0 |
|
Don’t Mail Flag |
NMNOMAIL |
L |
1 |
0 |
|
Don’t Email Flag |
NMELIST |
L |
1 |
0 |
|
Dwelling Type |
NMHMOWN |
C |
2 |
0 |
|
Educational Level |
NMEDLEVEL |
C |
2 |
0 |
|
Email Address |
NMEMAIL |
C |
75 |
0 |
|
Ethnic Origin |
NMETHNIC |
C |
2 |
0 |
|
Family Type |
NMFAMTYPE |
C |
6 |
0 |
|
Fax Phone |
NMFPHONE |
C |
15 |
0 |
|
Fee Category |
NMFEECAT |
C |
30 |
0 |
|
Firm ID |
NMFMID |
C |
12 |
0 |
|
Firm Name |
NMFIRM |
C |
75 |
0 |
|
Firm Reg Level (ACEweb Use) |
NMREGLVL |
N |
1 |
0 |
|
First Name |
NMNAME1 |
C |
30 |
0 |
|
Grouping |
NMGROUPID |
C |
9 |
0 |
|
Home Phone |
NMHPHONE |
C |
15 |
0 |
|
Household Income |
NMINC |
C |
3 |
0 |
| Ignore this name in Mass Combine Names | NMSKIPDUP | L | 1 | 0 |
|
Language |
NMLANG |
C |
2 |
0 |
|
Last Activity Date |
NMLASTACT |
D |
8 |
0 |
|
Last Name |
NMNAME3 |
C |
45 |
0 |
|
Line of Travel |
NMLINOTRV |
C |
5 |
0 |
|
Link File |
NMLINKFILE |
C |
100 |
0 |
|
Mail Stop |
NMMAILST |
C |
10 |
0 |
|
Marital Status |
NMMARSTAT |
C |
1 |
0 |
|
Member Number |
NMMEMBNUM |
C |
14 |
0 |
|
Middle Initial |
NMNAME2 |
C |
12 |
0 |
|
Miscellaneous Code 1 |
NMCODE1 |
C |
12 |
0 |
|
Miscellaneous Code 2 |
NMCODE2 |
C |
12 |
0 |
|
Miscellaneous Code 3 |
NMMISC |
C |
6 |
0 |
|
Number of Courses Taken |
NMNUMTAK |
N |
3 |
0 |
|
Occupational Code |
NMOCC |
C |
6 |
0 |
| Opt In | NMSMSOPT | L | 1 | 0 |
|
Organization Code |
NMORG |
C |
6 |
0 |
|
Pager Number |
NMPAGER |
C |
12 |
0 |
|
Preferred Address |
NMPREFER |
C |
1 |
0 |
|
Preferred Method of Contact |
NMPMOC |
C |
1 |
0 |
|
Print Label Flag |
NMPRTLBL |
L |
1 |
0 |
|
Print Label Information |
NMLABINFO |
C |
18 |
0 |
|
Province |
NMPROVINCE |
C |
20 |
0 |
| Renewed Member | NMRENEWMEM | L | 1 | 0 |
|
Report Flag |
NMRPTFLAG |
L |
1 |
0 |
|
Salutation |
NMSALUT |
C |
10 |
0 |
|
Sex (Gender) |
NMSEX |
C |
1 |
0 |
|
Source Code |
NMSOURCE |
C |
8 |
0 |
|
Special Needs |
NMSPEC |
M |
10 |
0 |
|
ID |
NMID |
C |
9 |
0 |
| SSO ID | NMSSOID | M | 10 | 0 |
|
State |
NMSTATE |
C |
2 |
0 |
|
Suffix |
NMSUFF |
C |
21 |
0 |
|
Title |
NMTITLE |
C |
50 |
0 |
|
Update Date |
NMUPDATE |
D |
8 |
0 |
|
Update Time |
NMUPTM |
C |
10 |
0 |
|
Updated By |
NMUSER |
C |
8 |
0 |
|
Who should Call Back |
NMWHOCALL |
C |
8 |
0 |
|
Zip |
NMZIP |
C |
10 |
0 |
| Additional Character Field (label specified by organization) | NMCHAR1 | C | 50 | 0 |
NAMEUDFS
Descriptions for the User Defined Fields are set by your organization. Labels are assigned from Edit > Preferences > Names tab > Name UDF's button.
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
ID |
NUID |
C |
9 |
0 |
|
User Defined Character 1 |
NUDFC1 |
C |
20 |
0 |
|
User Defined Character 2 |
NUDFC2 |
C |
20 |
0 |
|
User Defined Character 3 |
NUDFC3 |
C |
50 |
0 |
|
User Defined Character 4 |
NUDFC4 |
C |
50 |
0 |
|
User Defined Character 5 |
NUDFC5 |
C |
70 |
0 |
|
User Defined Date 1 |
NUDFD1 |
D |
8 |
0 |
|
User Defined Date 2 |
NUDFD2 |
D |
8 |
0 |
|
User Defined Date 3 |
NUDFD3 |
D |
8 |
0 |
|
User Defined Date 4 |
NUDFD4 |
D |
8 |
0 |
|
User Defined Date 5 |
NUDFD5 |
D |
8 |
0 |
|
User Defined Logical 1 |
NUDFL1 |
L |
1 |
0 |
|
User Defined Logical 2 |
NUDFL2 |
L |
1 |
0 |
|
User Defined Logical 3 |
NUDFL3 |
L |
1 |
0 |
|
User Defined Logical 4 |
NUDFL4 |
L |
1 |
0 |
|
User Defined Logical 5 |
NUDFL5 |
L |
1 |
0 |
|
User Defined Numeric 1 |
NUDFN1 |
N |
9 |
2 |
|
User Defined Numeric 2 |
NUDFN2 |
N |
8 |
2 |
|
User Defined Numeric 3 |
NUDFN3 |
N |
8 |
2 |
|
User Defined Numeric 4 |
NUDFN4 |
N |
8 |
2 |
|
User Defined Numeric 5 |
NUDFN5 |
N |
8 |
2 |
ORGANIZATION DEFAULTS
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Address Line 1 |
XC_ADDR1 |
C |
45 |
0 |
|
Address Line 2 |
XC_ADDR2 |
C |
45 |
0 |
|
City |
XC_CITY |
C |
25 |
0 |
|
Fax Phone |
XC_FPHONE |
C |
18 |
0 |
|
Global Receipt Message |
XC_RCPTMES |
C |
500 |
0 |
|
Organization Department |
XC_DEPTTIT |
C |
55 |
0 |
|
Organization Title |
XC_ORGTITL |
C |
60 |
0 |
|
Phone |
XC_PHONE |
C |
18 |
0 |
|
State |
XC_STATE |
C |
2 |
0 |
|
URL |
XC_URL |
C |
60 |
0 |
|
Zip Code |
XC_ZIP |
C |
10 |
0 |
| ACEweb URL | XS_AWURL | C | 250 | 0 |
PAY
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Account Code |
PYACCOUNT |
C |
30 |
0 |
| Add Time | PYADDTM | C | 10 | 0 |
|
Address Line 1 |
PYADDR1 |
C |
50 |
0 |
|
Address Line 2 |
PYADDR2 |
C |
50 |
0 |
|
Amount |
PYAMT |
N |
9 |
2 |
|
Auth #/Addl Info |
PYAUTHNUM |
C |
30 |
0 |
|
City |
PYCITY |
C |
25 |
0 |
|
Contact Person |
PYCONT |
C |
75 |
0 |
|
Course Code |
PYCRSE |
C |
12 |
0 |
|
Created By |
PYCREATOR |
C |
8 |
0 |
|
Credit Card Expiration Date |
PYEXPRDATE |
C |
10 |
0 |
|
Transaction # |
PYTRANUM |
C |
20 |
0 |
|
Credit Card, Check, or PO # |
PYNUMBER |
C |
20 |
0 |
|
Date |
PYDATE |
D |
8 |
0 |
|
Deposit Number |
PYACCTFOR |
C |
12 |
0 |
|
|
PYEMAIL |
C |
75 |
0 |
| Escrow Expiration | PYESCEXP | D | 8 | 0 |
| Gift Card # | PYGIFT | C | 8 | 0 |
|
Group ID |
PYPAYID |
C |
12 |
0 |
|
Pay Notes |
PYLINK |
C |
125 |
0 |
|
Name |
PYNAME |
C |
50 |
0 |
|
Note |
PYNOTE |
C |
100 |
0 |
| Original ID/Course | PYORIGINAL | C | 22 | 0 |
|
Paid By Taxpayer Flag |
PYTAXCR |
L |
1 |
0 |
|
Paid To Invoice (Invoice Number) |
PYINVNUM |
C |
8 |
0 |
|
Payment ID |
PYSUBID |
C |
12 |
0 |
|
ACEweb Session ID |
PYSESSION |
C |
15 |
0 |
|
Transaction ID |
PYTRANSID |
C |
45 |
0 |
|
Phone Number |
PYPHONE |
C |
20 |
0 |
|
Province |
PYPROVINCE |
C |
20 |
0 |
|
Quantifier |
PYQUANT |
C |
4 |
0 |
|
Receipt Number |
PYRECNUM |
C |
8 |
0 |
|
ID |
PYID |
C |
9 |
0 |
|
State |
PYSTATE |
C |
2 |
0 |
|
Type |
PYTYPE |
C |
1 |
0 |
|
Update Date |
PYUPDATE |
D |
8 |
0 |
|
Update Time |
PYUPTM |
C |
10 |
0 |
|
Updated By |
PYUSER |
C |
8 |
0 |
|
Zip |
PYZIP |
C |
10 |
0 |
| User Defined Character 1 | PYUDFC1 | C | 20 | 0 |
| User Defined Character 2 | PYUDFC2 | C | 20 | 0 |
| User Defined Date 1 | PYUDFD1 | D | 8 | 0 |
REGFEES
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Amount |
RFFEE |
N |
9 |
2 |
|
Course Code |
RFCRSE |
C |
12 |
0 |
| Date Added | RFDATE | D | 8 | 0 |
|
Fee Description |
RFDESC |
C |
30 |
0 |
|
Group ID |
RFGROUPID |
C |
12 |
0 |
|
Inventory Number |
RFINVNO |
C |
8 |
0 |
| Quantity | RFQUANT | N | 2 | 0 |
|
ID |
RFID |
C |
9 |
0 |
REGISTER
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Add Date |
RGADDATE |
D |
8 |
0 |
| Add Time | RGADDTIME | C | 10 | |
|
Adjustment Amount (No Longer Used) |
RGADJFEE |
N |
9 |
2 |
|
Adjustment Description (No Longer Used) |
RGADJDESC |
C |
30 |
0 |
|
Amount (Main) |
RGCRSEFEE |
N |
9 |
2 |
| Approved By | RGAPPROV | C | 9 | 0 |
|
Bill/Pay Only Record Flag |
RGBILL |
L |
1 |
0 |
|
canceled Flag |
RGCANCEL |
L |
1 |
0 |
|
Certificate Printed Date |
RGPTCERT |
D |
8 |
0 |
|
CEUS |
RGCEUS |
N |
7 | 3 |
|
Completed Course |
RGCOMPLETE |
D |
8 |
0 |
|
Completion Deadline Date |
RGEXPDATE |
D |
8 |
0 |
|
Confirmation Date |
RGCNFIRM |
D |
8 |
0 |
|
Course Code |
RGCRSE |
C |
12 |
0 |
|
Created By |
RGCREATOR |
C |
8 |
0 |
|
Credits |
RGCREDIT |
N |
4 |
1 |
|
Fee Description (Main) |
RGFEEDESC |
C |
30 |
0 |
| Get Web Certificate | RGWEBCERT | N | 1 | 0 |
|
Grade |
RGGRADE |
C |
3 |
0 |
|
Group Flag |
RGGROUP |
L |
1 |
0 |
|
Group ID |
RGGROUPID |
C |
12 |
0 |
|
Hours |
RGHOURS |
N |
7 |
2 |
| Hybrid Status | RGHYBRID | C | 1 | 0 |
|
Identifier |
RGIDENT |
C |
20 |
0 |
| Max Use | RGCLASMAX | N | 3 | 0 |
|
Miscellaneous Code |
RGMISC |
C |
6 |
0 |
|
Number of Seats |
RGNUMB |
N |
4 |
0 |
| Partner | RGPARTNER | C | 9 | 0 |
|
Publish (on ACEweb)? |
RGPUBLISH |
L |
1 |
0 |
|
Quantifier |
RGQUANT |
C |
4 |
0 |
| Registered By | RGPROXYID | C | 9 | 0 |
|
Registration Code |
RGCODE |
C |
6 |
0 |
|
Registration Note |
RGREGNOTE |
C |
250 |
0 |
|
ID |
RGID |
C |
9 |
0 |
|
Status |
RGSTATUS |
C |
15 |
0 |
|
Total Paid (No Longer Used) Flag |
RGTOTALPD |
L |
1 |
0 |
|
Tracking Code |
RGTRACK |
C |
8 |
0 |
|
Update Date |
RGUPDATE |
D |
8 |
0 |
|
Update Time |
RGUPDTTM |
C |
10 |
0 |
|
Updated By |
RGUSER |
C |
8 |
0 |
|
Waitlist Flag |
RGWAITLIST |
L |
1 |
0 |
|
Who Paid for Registration |
RGWHOPAY |
C |
1 |
0 |
REGUDFS
Descriptions for the User Defined Fields are set by your organization. Labels are assigned from Edit > Preferences > Registration tab > Register UDF's button.
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Course Code |
RUCRSE |
C |
12 |
0 |
|
ID |
RUID |
C |
9 |
0 |
|
User Defined Character 1 |
RUDFC1 |
C |
20 |
0 |
|
User Defined Character 2 |
RUDFC2 |
C |
20 |
0 |
|
User Defined Character 3 |
RUDFC3 |
C |
20 |
0 |
|
User Defined Character 4 |
RUDFC4 |
C |
50 |
0 |
|
User Defined Date 1 |
RUDFD1 |
D |
8 |
0 |
|
User Defined Date 2 |
RUDFD2 |
D |
8 |
0 |
|
User Defined Date 3 |
RUDFD3 |
D |
8 |
0 |
|
User Defined Date 4 |
RUDFD4 |
D |
8 |
0 |
|
User Defined Logical 1 |
RUDFL1 |
L |
1 |
0 |
|
User Defined Logical 2 |
RUDFL2 |
L |
1 |
0 |
|
User Defined Logical 3 |
RUDFL3 |
L |
1 |
0 |
|
User Defined Logical 4 |
RUDFL4 |
L |
1 |
0 |
|
User Defined Numeric 1 |
RUDFN1 |
N |
8 |
2 |
|
User Defined Numeric 2 |
RUDFN2 |
N |
8 |
2 |
|
User Defined Numeric 3 |
RUDFN3 |
N |
8 |
2 |
|
User Defined Numeric 4 |
RUDFN4 |
N |
8 |
2 |
ROOMSPLIT
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Parent | RSPARENT | C | 12 | |
| Child | RSCHILD | C | 12 | |
STATES
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Abbreviation |
ABBREV |
C |
2 |
0 |
|
Full name |
FULLNAME |
C |
20 |
0 |
TESTING
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Add Date | TEADDATE | D | 8 | |
| Code | TECODE | C | 15 | |
| Credits | TECREDITS | N | 7 | 2 |
| Date | TEDATE | D | 8 | |
| Date2 | TEDATE2 | D | 8 | |
| Hide from Web | TEHIDEWEB | L | 1 | |
| ID | TEID | C | 9 | |
| Institution | TEINSTITU | C | 40 | |
| Notes | TENOTES | C | 75 | |
| Score | TESCORE | C | 12 | |
| Title | TETITLE | C | 75 | |
| Type | TETYPE | C | 8 | |
| Updated By | TEUSER | C | 8 | |
USER DEFINED LABELS
The following is a list of Student Manager User Defined Labels. The Label Name can be used on reports to display the user defined label of the corresponding field. Labels can be changed from Edit > Preferences > specified tab.
| TAB | PREFERENCE | LABEL NAME | DATA FIELD NAME |
| Course | Cochar1 | xs_coordlab | cocoord |
| Course | Coordinator | xs_cochar1 | cochar1 |
| Course | 1 (Instructor Evaluation Fields) | xs_lievl1 | liev1 |
| Course | 2 (Instructor Evaluation Fields) | xs_lievl2 | liev2 |
| Course | 3 (Instructor Evaluation Fields) | xs_lievl3 | liev3 |
| Course | 4 (Instructor Evaluation Fields) | xs_lievl4 | liev4 |
| Course | 5 (Instructor Evaluation Fields) | xs_lievl5 | liev5 |
| Course | 6 (Instructor Evaluation Fields) | xs_lievl6 | liev6 |
| Course | 7 (Instructor Evaluation Fields) | xs_lievl7 | liev7 |
| Faculty | Code Label | xs_incode1 | incode1 |
| Faculty | Referen Label | xs_refer | inreferen |
| Faculty | Resume Label | xs_resume | inresume |
| Firm | Char 1 | xs_fmchar1lab | fmchar1 |
| Firm | Char 2 | xs_fmchar2lab | fmchar2 |
| Firm | Firm Rep | xs_replab | fmrep |
| Firm | Log 1 | xs_fmlog1lab | fmlog1 |
| Firm | Log 2 | xs_fmlog2lab | fmlog2 |
| Firm | SIC | xs_siclab | fmsic |
| Names | Badge Name | xs_badge | nmbadge |
| Names | Disability | xs_disabil | nmdisable |
| Names | Education Level | xs_edlevel | nmedlevel |
| Names | Ethnic Origin | xs_ethlab | nmethnic |
| Names | Family Type | xs_famtype | nmfamtype |
| Names | Homeowner | xs_homeown | nmhmown |
| Names | Household Income | xs_housinc | nminc |
| Names | Language | xs_langlab | nmlang |
| Names | Marital Status | xs_marstat | nmmarstat |
| Names | Member Number | xs_memlab | nmmembnum |
| Names | Miscellaneous Code | xs_nmmisclab | nmmisc |
| Names | Name Char 1 | xs_char1lab | nmchar1 |
| Names | NMCODE1 | xs_nmcode1 | nmcode1 |
| Names | NMCODE2 | xs_nmcode2 | nmcode2 |
| Names | Occupation | xs_occ | nmocc |
| Names | Organization | xs_org | nmorg |
| Names | Pager Phone | xs_pager | nmpager |
| Pay | (7) | xs_paytyp7 | Payment Type drop down list |
| Pay | (A) | xs_paytypa | Payment Type drop down list |
| Pay | (B) | xs_paytypb | Payment Type drop down list |
| Pay | (C) | xs_paytypc | Payment Type drop down list |
| Pay | (D) | xs_paytypd | Payment Type drop down list |
| Pay | (E) | xs_paytype | Payment Type drop down list |
| Pay | (F) | xs_paytypf | Payment Type drop down list |
| Pay | (G) | xs_paytypg | Payment Type drop down list |
| Pay | (H) | xs_paytyph | Payment Type drop down list |
| Register | Reg Code | xs_crgcode | rgcode |
| Register | Use rgptcert (Date Field) | xs_certlab | rgptcert |
| Register | Use rgconfirm (Date Field) | xs_conflab | rgcnfirm |
| Register | Use rgmisc | xs_misclab | rgmisc |
USER PROFILE
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
| Full Name | m.fullname | C | 30 |
0 |
| User Name | m.usermast | C | 8 |
0 |
| Email Address | m.usremail | C | 40 | 0 |
| Phone Number | m.usrphone | C | 15 | 0 |
| ACEweb Skin Number | xl_awskin | N | 1 | 0 |
| Email Signature | emailsig | M | 10 | 0 |
| HTML Email Signature | emsightml | M | 10 | 0 |
WKSHPIND
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
CEUS |
WICEUS |
N |
7 | 3 |
|
Course Code |
WICRSE |
C |
12 |
0 |
|
Date Lesson Received |
WIRCVDATE |
D |
8 |
0 |
|
Date Lesson Returned |
WIRTNDATE |
D |
8 |
0 |
|
Hours |
WIHOUR |
N |
6 |
2 |
|
Lesson Faculty ID |
WIINSTR |
C |
12 |
0 |
|
Lesson Grade |
WIGRADE |
C |
7 |
0 |
|
Lesson Flag |
WILESSON |
L |
1 |
0 |
|
Quantifier |
WIQUANT |
C |
4 |
0 |
|
ID |
WIID |
C |
9 |
0 |
|
Test Request Date |
WITESTREQ |
D |
8 |
0 |
|
Workshop Code |
WICODE |
C |
8 |
0 |
WKSHPMST
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Amount |
WMFEEAMT |
N |
8 |
2 |
|
CEUS |
WMCEUS |
N |
7 | 3 |
|
Course Code |
WMCRSE |
C |
12 |
0 |
|
Date |
WMDATE |
D |
8 |
0 |
|
Do Not Display on ACEweb |
WMWEBHIDE |
L |
1 |
0 |
|
Enrollment Count |
WMENROLL |
N |
5 |
0 |
|
Fee Description |
WMFEEDESC |
C |
30 |
0 |
|
Hours |
WMHOUR |
N |
6 |
2 |
|
Leader |
WMLEADER |
C |
50 |
0 |
|
Location |
WMLOC |
C |
20 |
0 |
|
Maximum Size |
WMMAX |
N |
4 |
0 |
|
Note |
WMNOTE |
C |
120 |
0 |
|
Option 1 |
WMOPT1 |
C |
15 |
0 |
|
Option 2 |
WMOPT2 |
C |
15 |
0 |
|
Times |
WMTIME |
C |
20 |
0 |
|
Title |
WMTITLE |
C |
95 |
0 |
|
Workshop Code |
WMCODE |
C |
8 |
0 |
|
Workshop Description Code |
WMCATCODE |
C |
10 |
0 |
ZIP
|
LABEL |
FIELD NAME |
TYPE |
LENGTH |
|
|
Area Code |
ZIPAREA |
C |
3 |
0 |
|
City |
ZIPCITY |
C |
20 |
0 |
|
Country |
ZIPCNTRY |
C |
20 |
0 |
|
County |
ZIPCOUNTY |
C |
15 |
0 |
|
Region |
ZIPREGION |
C |
3 |
0 |
|
State |
ZIPSTATE |
C |
2 |
0 |
|
Zip |
ZIPZIP |
C |
10 |
0 |
