Penn Computing

University of Pennsylvania
Penn Computing << go backback
ENTRY_STATUS Table . Tables and Data Elements . Housing Home . Data Warehouse Home

ENTRY_STATUS Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Abbreviation

Indexed - no
Format - Varchar2(16)
May be Null? N

Description

Indexed - no
Format - Varchar2(80)
May be Null? N

Entrystatusenum

Indexed - yes
Format - Number
May be Null? N

Unique Identifier.
0 = Admin ADMN
1= Tentative TENT
2 = Reserved RESV
3 = Held HELD
5 = In-Room INRM
10 = History HIST
20 = Occupant OCC
21 = Occupant History OCCH
22 = Occupied In Room OCCR
30 = Attendee ATT
31 = Attendee Arrived ATTA
32 = Attendee Departed ATTD
40 = Account ACCT
50 = Master Account MAST
70 = Cancelled CNCL
75 = Erased ERSD
80 = Applicaiton APP
90 = Incident INC
100 = Contact CON
110 = Alumni ALM

ENTRY_STATUS Table . Tables and Data Elements . Housing Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania