ER.ER_UNVL_USR_T - Electronic Research Administration

ERA Universal (User ID) User Table

This is a table in tablespace ER.

Purpose: This table holds information about people. It is populated periodically by a script that fetches the data from a Human Resources system.

Schema

name	human readable name	type	size	scale	null	indexed
ACAD_APPT_TYP_CD	Academic Appointment Type Code	VARCHAR2	2		Yes	No
EMP_FSCL_CMP_CD	Employee Fiscal Campus Code	VARCHAR2	2		Yes	No
EMP_PRM_DEPT_CD	Employee Primary Department Code	VARCHAR2	4		Yes	No
EMP_STAT_CD	Employee Status Code	VARCHAR2	1		Yes	No
EMP_TYPE_CD	Employee Type Code	VARCHAR2	1		Yes	No
PERSON_SSN_ID	Person Social Security Number Identifier	VARCHAR2	9		No	No
PERSON_UNVL_ID	Person Universal (User ID) Identifier	VARCHAR2	10		No	Yes
PERSON_USER_ID	Person User Identifier	VARCHAR2	8		Yes	Yes
PRSN_1ST_NM	Person First Name	VARCHAR2	20		Yes	Yes
PRSN_BASE_SLRY	Person Base Salary	NUMBER	19	4	Yes	No
PRSN_CMP_ADDR	Person Campus Address	VARCHAR2	55		Yes	No
PRSN_EMAIL	Person Email	VARCHAR2	40		Yes	No
PRSN_LOC_PHN	Person Location Phone	VARCHAR2	10		Yes	No
PRSN_LST_NM	Person Last Name	VARCHAR2	20		Yes	Yes
PRSN_UNIV_ID	Person University Identifier	VARCHAR2	11		Yes	Yes
U_VERSION	Uniface Version	VARCHAR2	1		Yes	No

Potential Foreign Key Relationships

local column name	qualified foreign column name	caveats	comment
PERSON_UNVL_ID	ER.ER_ACC_STSTC_T.PERSON_UNVL_ID	Indexed does not match (local:"yes" foreign:"no") Size does not match (local:"10" foreign:"11") foreign column is not indexed
PRSN_BASE_SLRY	ER.ER_USER_V.PRSN_BASE_SLRY	Nulls does not match (local:"Yes" foreign:"?") Size does not match (local:"19" foreign:"25") foreign column is not indexed

Indexes

name	column name	column position	direction
ER_UNVL_USR_TI2	PERSON_USER_ID	1	ASC
ER_UNVL_USR_TI3	PRSN_UNIV_ID	1	ASC
ER_UNVL_USR_TI4	PRSN_LST_NM	1	ASC
ER_UNVL_USR_TI5	PRSN_1ST_NM	1	ASC
ER_UNVL_USR_TP1	PERSON_UNVL_ID	1	ASC

Source Code References

file name	line number	quote
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/ApproverDelegat eDomain.java	72	"ER_UNVL_USR_T.PRSN_LST_NM, ER_UNVL_USR_T.PRSN_1ST_NM", help er);
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/ApproverDelegat eDomain.java	90	"ER_UNVL_USR_T",
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/OrgApprovalPers onDomain.java	67	"ER_UNVL_USR_T",
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/OrgApprovalPers onDomain.java	69	"PERSON_UNVL_ID"); // ER_UNVL_USR_T columns
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/OrgApprovalPers onDomain.java	133	whereClause.append("ER_UNVL_USR_T.PRSN_LST_NM like ");
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/OrgApprovalPers onDomain.java	141	whereClause.append("ER_UNVL_USR_T.PRSN_1ST_NM like ");
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/OrgApprovalPers onDomain.java	149	whereClause.append("ER_UNVL_USR_T.PERSON_USER_ID like ");
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/UserGroupDomain .java	97	"ER_UNVL_USR_T.PRSN_LST_NM", jHelper);
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/UserGroupDomain .java	103	// Join Tables ER_UNVL_USR_T to ER_USR_GROUP_T
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/UserGroupDomain .java	106	"ER_UNVL_USR_T",
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/UserGroupDomain .java	107	"PERSON_UNVL_ID", // ER_UNVL_USR_T column
erasrc/ERA/src/edu/iu/uis/fps/er/data/maintenance/MT_G_User2 DomainSuper.java	65	this.setTableName("ER_UNVL_USR_T");
erasrc/ERA/src/edu/iu/uis/fps/er/data/routingForm/RF_Proposa lDiaryDomain.java	71	"ER_UNVL_USR_T",
erasrc/ERA/src/edu/iu/uis/fps/er/logic/global/BudgetRoutingF ormLinkController.java	313	statement2.append(" (select ER_BDGT_T.BDGT_PROJ_DRCTR_UID as PERSON_UNVL_ID, ER_UNVL_USR_T.EMP_FSCL_CMP_CD as PRPSL_PJD_ COA_CD,");
erasrc/ERA/src/edu/iu/uis/fps/er/logic/global/BudgetRoutingF ormLinkController.java	314	statement2.append(" ER_UNVL_USR_T.EMP_PRM_DEPT_CD as PRPSL_P JD_ORG_CD");
erasrc/ERA/src/edu/iu/uis/fps/er/logic/global/BudgetRoutingF ormLinkController.java	315	statement2.append(" FROM ER_BDGT_T, ER_UNVL_USR_T");
erasrc/ERA/src/edu/iu/uis/fps/er/logic/global/BudgetRoutingF ormLinkController.java	316	statement2.append(" WHERE ER_BDGT_T.BDGT_PROJ_DRCTR_UID = ER _UNVL_USR_T.PERSON_UNVL_ID(+)");

DDL SQL

CREATE TABLE "ER"."ER_UNVL_USR_T" ("PERSON_UNVL_ID" VARCHAR2(10 
    byte) NOT NULL, "U_VERSION" VARCHAR2(1 byte), 
    "PERSON_USER_ID" VARCHAR2(8 byte), "PRSN_1ST_NM" VARCHAR2(20 
    byte), "PRSN_LST_NM" VARCHAR2(20 byte), "EMP_FSCL_CMP_CD" 
    VARCHAR2(2 byte), "EMP_PRM_DEPT_CD" VARCHAR2(4 byte), 
    "EMP_STAT_CD" VARCHAR2(1 byte), "EMP_TYPE_CD" VARCHAR2(1 
    byte), "PERSON_SSN_ID" VARCHAR2(9 byte) NOT NULL, 
    "PRSN_EMAIL" VARCHAR2(40 byte), "PRSN_CMP_ADDR" VARCHAR2(55 
    byte), "PRSN_LOC_PHN" VARCHAR2(10 byte), "PRSN_BASE_SLRY" 
    NUMBER(19, 4), "PRSN_UNIV_ID" VARCHAR2(11 byte), 
    "ACAD_APPT_TYP_CD" VARCHAR2(2 byte))  
    TABLESPACE "ER" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 
    STORAGE ( INITIAL 30240K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
    MONITORING