University of Memphis | Data Standards | Back to Contents
APPENDIX F - UM Table: Banner Shared Tables
Validation Tables Control Forms PIDM-Related Tables
Validation Tables Table Description Student Fin. Aid Advance. Finance HR FTVACCI Account Index Code - - x x x FTVACCT Account Code - - x x x FTVACTV Activity Code - - x x x FTVCOAS Chart of Account - - x x x FTVFUND Fund Code - - x x x FTVLOCN Location Code - - x x x FTVORGN Organization Code - x x x x FTVPROG Program Code - - x x x GTVZIPC ZIP/Postal Code x x x x x GTVNTYP Name Type x x x - x GTVEMAL Email Type x x x - x GTVEXPN Expenses x - x - - GTVSUBJ Subject Index x - x - - GTVMAIL Mail Type x - x - - STVACCG Activity Category x x x - - STVACTC Activity Code x - x - - STVACTP Activity Type x - x - - STVACYR Academic Year Code x x x - - STVASRC Address Source x - x x x STVATYP Address Type Code x x x x x STVCAMP Campus Code x x x - x STVCIPC CIPC Code x - - - x STVCITZ Citizen Type Code x x x - x STVCLAS Class Code x x - - - STVCOMT Committee/Serv. Type x - - - x STVCNTY County Code x x x x x STVCOLL College Code x x x - x STVCTYP Contact Type x x - - - STVDAYS Days of the Week x x - - - STVDEGC Degree Code x x x - x STVDEPT Department Code x - x - - STVDLEV Degree Level x - - - x STVEMPT Employment Type x - - - - STVETHN Ethnic Code x x x - x STVGEOD Geographic Region Div. x - x - - STVGEOR Geographic Region Code x - x - - STVGMOD Grading Mode Code x x - - - STVHOND Dept'l Honors Code x x x - - STVHONR Institut'l Honors Code x - x - - STVINIT Initials Code x - x - - STVLANG Language x - - - x STVLEAD Leadership x - x - - STVLEVL Level Code x x - - - STVLGCY Legacy x - x - x STVMAJR Major/Minor/Conc. Code x x x - x STVMDEQ Medical Equipment Code x - - - x STVMEDI Medical Code x - - - x STVMRTL Marital Status Code x x x - x STVNATN Nation Code x x x x x STVORIG Originator Code x - x - - STVPENT Port of Entry Code x - - - x STVRELG Religion Code x - x - x STVRELT Relation Code x - - - x STVRSTS Crs Registration Status x x - - - STVSBGI Source/Background Inst x x x - x STVSTAT State/Province Code x x x x x STVTELE Telephone Type x x x x x STVTERM Term Type x x - - - STVVTYP VISA Type x - - - x STVAPDC Adm Applic Decision Cds x x - - - STVWDRL Stdt Withdrwl Stat Cds x x - - - TSA1098 1098-T Tax Info - - - x - TSAACCT Acct Review - Student - - - x - TSAADSP Applic Dist Single Pay - Stdt - - - x - TSAAREV Acct Detail Rev - Stdt - - - x - TSACONP Contract Person Auth - - - x - TSACONT Contract Authorization - - - x - TSADETF Student Acct Detail - - - x - TSAEXPP Exemption Person Auth - - - x - TSAEXPT Exemption Authorization - - - x - TSAISTL Install Plan - Student - - - x - TSAISTP Install Plan Pay Amount - - - x - TSALBOX Lockbox Correction - - - x - TSAMASS Billing Mass Data Entry - Student - - - x - TSAMISC Misc Transaction - Stdt - - - x - TSAMUNA Mass Unapplictn - Stdt - - - x - TSARFND Refund Review - Stdt - - - x - TSASPAY Student Payment - - - x - TSATAXN Stdt Tax Notification - - - x - TSAUNAP Stdt Unapplictn Paymnt - - - x -
Control or Rule Forms Table Description Student Fin. Aid Advance. Finance HR PTRCALN Payroll Cal. Rule Form - x - - x SORTBRK Stdt Term Break Form x x - - - TSADETC Detail Code Ctrl Form x x - - - TSAEXPT Exemption Author. Form x x - - - TSACONT Contract Author. Form x x - - - TSAISTA Auto Install Plan Assign - - - x - TSAISTR Auto Install Plan Rules - - - x - TSATAXR Tax Reporting Rules - - - x - TSATERM AR Term Control - - - x - TSATPRL Third Party Billing Rules - - - x - TVVAUTH Author. Validation Form x x - - -
PIDM-Related Tables (Alumni, Student, Faculty, Employee) Table Description Student Fin. Aid Advance. Finance HR GOREMAL x x x x x GURAPAY Accounting AP Feed Tbl x - - x - GURFEED Fin. Trans. Input Tbl x - x x x SPBPERS General Person x x x x x SPRADDR Address x x x x x SPRIDEN Identification Table x x x x x SPRTELE Telephone x x x x x
University of Memphis | Data Standards | Back to Contents