EMPLIDY/N Table Edit
Default Value: N
USRPRF_LTR_COMM(SQL Table) |
Index Back |
|---|---|
CC Oper Load - Letter Genthis table holds the info that institution will send out |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 3 | EVENT_3CS_ID | Character(10) | VARCHAR2(10) NOT NULL | 3Cs event ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | USRPRO_PSWD | Character(32) | VARCHAR2(32) NOT NULL | unencripted password field for Oper Load process |
| 6 | READY_TO_DEL | Character(1) | VARCHAR2(1) NOT NULL |
Ready to delete
Y/N Table Edit Default Value: N |