| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 3 |
SEQ_3C |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 4 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 5 |
VAR_DATA_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Variable Data Sequence Number
|
| 6 |
EMPLID_RELATED |
Character(11) |
VARCHAR2(11) NOT NULL |
Related People ID
|
| 7 |
JOINT_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Joint Communications
|
| 8 |
INCLUDE_ENCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Enclosures
Y/N Table Edit
|
| 9 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 10 |
ADDR_NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Address Name Type
|
| 11 |
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
|
| 12 |
SALUTATION_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salutation Type
|
| 13 |
NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of Name
|
| 14 |
JOINT_NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Joint Name Type
|
| 15 |
JOINT_PRIMARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary
|
| 16 |
RELATIONSHIP_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Relationship Nbr
|
| 17 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 18 |
SCC_COMM_LANG |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Used
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 19 |
SCC_COMM_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Method Used
B=Publication
D=Document
E=E-Mail
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web
|
| 20 |
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
|
| 21 |
PRODUCE_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Produce Communication
Y/N Table Edit
Default Value: Y
|
| 22 |
COMM_UPDATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication Updated?
|