| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 2 |
MC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Mass Change Status
APR=Approved Transaction
CAN=Cancel Transaction
ERR=Errored Transaction
PND=Pending Transaction
SCS=Successful Transaction
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 5 |
ADMIN_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table:
ADM_FUNCTN_TBL
|
| 6 |
COMM_KEY |
Character(8) |
VARCHAR2(8) NOT NULL |
Communication Speed Key
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: COMM_SPDKEY_TBL.DESCR
|
| 9 |
COMM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table:
COMM_CATG_TBL
|
| 10 |
COMM_CONTEXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table:
COMM_CA_CTX_TBL
|
| 11 |
COMM_DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
|
| 12 |
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_TBL
|
| 13 |
COMM_DIRECTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Communication Direction
IN=Incoming Communication
OUT=Outgoing Communication
PERS=In Person
|
| 14 |
UNSUCCESSFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Unsuccessful Outcome
Y/N Table Edit
Default Value: N
|
| 15 |
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
|
| 16 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
|
| 17 |
COMMENT_PRINT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Comments for Communications
Y/N Table Edit
Default Value: N
|
| 18 |
ACTIVITY_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Completed
Y/N Table Edit
Default Value: N
|
| 19 |
COMM_DT |
Date(10) |
DATE |
Communication Date
|
| 20 |
COMM_DTTM |
DateTime(26) |
TIMESTAMP |
Communication DateTime
|
| 21 |
COMM_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Person responsible for the communication
|
| 22 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 23 |
COMPLETED_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication Completed
Y/N Table Edit
|
| 24 |
COMPLETED_DT |
Date(10) |
DATE |
Date Activity Completed
|
| 25 |
COMPLETED_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Completed ID
|