| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN
|
| 2 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
Prompt Table:
MC_DEFN_SA_VW
|
| 3 |
USER_ID_ALGORITHM |
Character(4) |
VARCHAR2(4) NOT NULL |
For User IDs
EMAL=Email
EMPL=ID
|
| 4 |
PASSWORD_ALGORITHM |
Character(4) |
VARCHAR2(4) NOT NULL |
For Passwords
NAME=First Name, Last Name, ID
RAND=Random Creation
|
| 5 |
ALGO_EMAIL_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business
CAMP=Campus
DORM=Dorm
HOME=Home
OTHR=Other
PREF=Preferred
|
| 6 |
SEND_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign 3C
Y/N Table Edit
Default Value: N
|
| 7 |
POPU_USRPRF_TMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Create result table
Y/N Table Edit
Default Value: N
|
| 8 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 9 |
EVENT_3CS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
3Cs event ID
Prompt Table:
USRPRF_3C_VW
|
| 10 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
PSOPRDEFN
|
| 11 |
OPRALIASTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
User ID Type
Prompt Table:
CC_USERTYPEVW
|
| 12 |
E_ADDR_TYP2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
PREF=Preferred
|
| 13 |
EMAILTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Type
BB=Blackberry
BUS=Business
HOME=Home
OTH=Other
WORK=Work
|