The Stellar data tables are accessed directly, using JDBC.
User:
Property names used in Stellar 1.x
| property name | count | status |
|---|---|---|
| accountSponsor | 2799 | |
| adminNote | 2 | depricated |
| athena | 146 | depricated |
| officeLocation | 47080 | |
| officePhone | 37206 | |
| personType | 55214 | |
| year | 977 | depricated |
Standard API property names
| 1.x row or property name | api property | derived property | include untranslated |
|---|---|---|---|
| O_USER.name | username | no | |
| O_USER.longName | commonName | initials | no |
| O_USER.email | emailAddress | no | |
| O_USER.firstName | givenName | yes | |
| O_USER.middleName | yes | ||
| O_USER.lastName | surname, nameSortingField | yes | |
| O_USER.nickName | nickname | no | |
| accountSponsor | yes | ||
| officeLocation | yes | ||
| officePhone | yes | ||
| personType | yes |
Nexus:
Property names used in Stellar 1.x
| property name | count | status |
|---|---|---|
| archStyle | 114 | |
| defaultWorldLogin | 3986 | |
| descriptionIsXml | 2359 | |
| enableCompoundDocumentUploads | 991 | |
| enableJive | 4858 | depricated |
| enableJiveAuthUser | 859 | depricated |
| enableJiveAuthUserPost | 12 | depricated |
| enableMeetingsInfoField | 859 | |
| enableTransfer | 4235 | |
| hasSections | 322 | |
| homePageImageAlt | 1958 | |
| homePageImageCaptionXml | 1952 | |
| homeworkIsCalled | 1118 | |
| homeworkLinkText | 893 | |
| hwSubmissionDownloadZipIncludeOriginalName | 5 | |
| hwSubmissionDownloadZipSeparateDirectories | 5 | |
| infoTextLabel | 361 | |
| infoTextPublic | 1830 | |
| instructorLabel | 347 | |
| isSection | 1021 | |
| link10arrow | 2240 | |
| link10href | 2080 | |
| link10isAbsolute | 119 | |
| link10text | 2066 | |
| link10url | 4 | |
| link11arrow | 2210 | |
| link11href | 2039 | |
| link11isAbsolute | 87 | |
| link11text | 2028 | |
| link11url | 2 | |
| link12arrow | 1980 | |
| link12href | 1799 | |
| link12isAbsolute | 99 | |
| link12text | 1792 | |
| link13arrow | 1952 | |
| link13href | 1769 | |
| link13isAbsolute | 75 | |
| link13text | 1764 | |
| link14arrow | 1953 | |
| link14href | 1772 | |
| link14isAbsolute | 76 | |
| link14text | 1767 | |
| link15arrow | 4826 | |
| link15href | 4803 | |
| link15isAbsolute | 61 | |
| link15text | 4793 | |
| link16arrow | 4825 | |
| link16href | 4756 | |
| link16isAbsolute | 76 | |
| link16text | 4544 | |
| link17arrow | 2179 | |
| link17href | 1979 | |
| link17isAbsolute | 81 | |
| link17text | 1963 | |
| link18arrow | 2183 | |
| link18href | 2001 | |
| link18isAbsolute | 61 | |
| link18text | 1977 | |
| link19arrow | 4823 | |
| link19href | 4805 | |
| link19isAbsolute | 3 | |
| link19text | 4775 | |
| link1arrow | 2984 | |
| link1href | 4595 | |
| link1isAbsolute | 14 | |
| link1text | 4841 | |
| link1url | 10 | |
| link20arrow | 4752 | |
| link20href | 4738 | |
| link20isAbsolute | 2 | |
| link20text | 4728 | |
| link21arrow | 2488 | |
| link21href | 2312 | |
| link21isAbsolute | 3 | |
| link21text | 2298 | |
| link22arrow | 4753 | |
| link22href | 4743 | |
| link22isAbsolute | 1 | |
| link22text | 4736 | |
| link23arrow | 4522 | |
| link23href | 4513 | |
| link23isAbsolute | 5 | |
| link23text | 4514 | |
| link24arrow | 24 | |
| link24href | 22 | |
| link24isAbsolute | 17 | |
| link24text | 18 | |
| link25arrow | 11 | |
| link25href | 10 | |
| link25isAbsolute | 8 | |
| link25text | 10 | |
| link26arrow | 5 | |
| link26href | 3 | |
| link26isAbsolute | 3 | |
| link26text | 4 | |
| link27arrow | 4 | |
| link27href | 4 | |
| link27isAbsolute | 2 | |
| link27text | 4 | |
| link28arrow | 3 | |
| link28href | 2 | |
| link28isAbsolute | 1 | |
| link28text | 2 | |
| link2arrow | 2309 | |
| link2href | 2199 | |
| link2isAbsolute | 145 | |
| link2text | 2171 | |
| link2url | 10 | |
| link30arrow | 3 | |
| link30href | 1 | |
| link30isAbsolute | 1 | |
| link30text | 1 | |
| link3arrow | 4837 | |
| link3href | 4836 | |
| link3isAbsolute | 86 | |
| link3text | 4830 | |
| link3url | 10 | |
| link4arrow | 4839 | |
| link4href | 4838 | |
| link4isAbsolute | 95 | |
| link4text | 4825 | |
| link4url | 10 | |
| link5arrow | 2636 | |
| link5href | 2537 | |
| link5isAbsolute | 115 | |
| link5text | 2521 | |
| link5url | 10 | |
| link6arrow | 4839 | |
| link6href | 4830 | |
| link6isAbsolute | 93 | |
| link6text | 4799 | |
| link6url | 10 | |
| link7arrow | 2635 | |
| link7href | 2531 | |
| link7isAbsolute | 194 | |
| link7text | 2495 | |
| link7url | 10 | |
| link8arrow | 2730 | |
| link8href | 2619 | |
| link8isAbsolute | 154 | |
| link8text | 2610 | |
| link8url | 10 | |
| link9arrow | 2267 | |
| link9href | 2126 | |
| link9isAbsolute | 128 | |
| link9text | 2110 | |
| link9url | 8 | |
| masterSubjectID | 2663 | |
| meetPlace | 333 | |
| meetTime | 278 | |
| meeting1location | 3882 | |
| meeting1time | 3888 | |
| meeting1type | 4100 | |
| meeting2location | 2138 | |
| meeting2time | 2139 | |
| meeting2type | 2139 | |
| meeting3location | 2139 | |
| meeting3time | 2139 | |
| meeting3type | 2139 | |
| meeting4location | 2138 | |
| meeting4time | 2138 | |
| meeting4type | 2138 | |
| meeting5location | 2139 | |
| meeting5time | 2138 | |
| meeting5type | 2138 | |
| meetingsInfoXml | 12 | |
| nonAcademic | 233 | |
| publicHome | 3968 | |
| readOnly | 3168 | |
| section | 5046 | |
| sectionsAllowSwitch | 189 | |
| sectionsLastSwitchDay | 189 | |
| sectionsLastSwitchMonth | 189 | |
| sectionsLastSwitchYear | 189 | |
| sectionsMaxStudentsPer | 189 | |
| showContentDetails | 4828 | |
| showLink1 | 4578 | |
| showLink10 | 4829 | |
| showLink11 | 4826 | |
| showLink12 | 4826 | |
| showLink13 | 4826 | |
| showLink14 | 4826 | |
| showLink15 | 4826 | |
| showLink16 | 4826 | |
| showLink17 | 4820 | |
| showLink18 | 4820 | |
| showLink19 | 4820 | |
| showLink2 | 4837 | |
| showLink20 | 4748 | |
| showLink21 | 4746 | |
| showLink22 | 4745 | |
| showLink23 | 4579 | |
| showLink24 | 26 | |
| showLink25 | 12 | |
| showLink26 | 6 | |
| showLink27 | 5 | |
| showLink28 | 3 | |
| showLink3 | 4837 | |
| showLink30 | 3 | |
| showLink4 | 4837 | |
| showLink5 | 4837 | |
| showLink6 | 4837 | |
| showLink7 | 4837 | |
| showLink8 | 4837 | |
| showLink9 | 4833 | |
| showOcwLink | 1142 | |
| showRSS | 2171 | |
| showTopicsDetails | 4829 | |
| taLabel | 151 | |
| term | 5009 | |
| timezones | 6225 |