| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 3 |
ADMIN_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table:
ADM_FUNCTN_TBL
|
| 4 |
COMM_KEY |
Character(8) |
VARCHAR2(8) NOT NULL |
Communication Speed Key
Prompt Table:
COMM_SPDKEY_VW1
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: OPR_COMM_SPDKEY.DESCR
|
| 7 |
COMM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table:
COMM_CATG_VW
|
| 8 |
COMM_CONTEXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table:
COMM_CA_CTX_TBL
|
| 9 |
COMM_DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
|
| 10 |
COMM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication Method
B=Publication
D=Document
E=Email
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web
Prompt Table:
COMM_CTX_ME_VW2
|
| 11 |
UNSUCCESSFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Unsuccessful Outcome
Y/N Table Edit
Default Value: N
|
| 12 |
OUTCOME_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Outcome Reason
C=Missing Critical Data
E=Invalid Email Address
M=Left Message on Machine
N=No Answer
O=No Org Recipients found
P=Left Message with Person
R=Returned Mail
S=Email Send Error
|
| 13 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table:
COMM_CTX_ME_VW
|
| 14 |
COMMENT_PRINT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Comments for Communications
Y/N Table Edit
Default Value: N
|
| 15 |
ACTIVITY_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Completed
Y/N Table Edit
Default Value: N
|
| 16 |
COMMENTS |
Long Character |
CLOB |
Comment
|