DRTRYENGINE_AET

(SQL Table)
Index Back

community Dir State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 MC_GROUP_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Group ID
5 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
6 MC_STMNT_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Statement Sequence
7 MC_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Sequence
8 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
9 MC_SQL_STMNT Character(200) VARCHAR2(200) NOT NULL Mass Change SQL Statement
10 SQLTEXT Long Character(14000) CLOB SQL Statement Text
11 CHECK_FERPA Character(1) VARCHAR2(1) NOT NULL Check Ferpa switch used for indicating if Ferpa needs to be evaluated in the Dir_Data_Table page.
12 EXIST Character(1) VARCHAR2(1) NOT NULL Currency Exist
13 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

Prompt Table: NAME_TYPE_TBL

14 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
15 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: ADDRESS_TYP_TBL

16 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other