| # |
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 |
CG_SEQ |
Number(5,0) |
INTEGER NOT NULL |
CommGen Sequence
|
| 5 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
|
| 6 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 7 |
VAR_DATA_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Variable Data Sequence Number
|
| 8 |
EMPLID_RELATED |
Character(11) |
VARCHAR2(11) NOT NULL |
Related People ID
|
| 9 |
JOINT_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Joint Communications
|
| 10 |
INCLUDE_ENCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Enclosures
|
| 11 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 12 |
ADDR_NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Address Name Type
|
| 13 |
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
|
| 14 |
SALUTATION_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salutation Type
|
| 15 |
NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of Name
|
| 16 |
JOINT_NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Joint Name Type
|
| 17 |
JOINT_PRIMARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary
|
| 18 |
RELATIONSHIP_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Relationship Nbr
|
| 19 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 20 |
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
|
| 21 |
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
|
| 22 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 23 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 24 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 25 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 26 |
ORG_RECIPIENT |
Character(50) |
VARCHAR2(50) NOT NULL |
Org Communication Recipient
|
| 27 |
NAME_RESULT_P_ADDR |
Character(120) |
VARCHAR2(120) NOT NULL |
Name Result
|
| 28 |
NAME_RESULT_P_EXTR |
Character(120) |
VARCHAR2(120) NOT NULL |
Name Result
|
| 29 |
NAME_RESULT_P_SAL |
Character(120) |
VARCHAR2(120) NOT NULL |
Name Result
|
| 30 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 31 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 32 |
SQL_TEXT1 |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Text 1
|
| 33 |
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
|
| 34 |
PRODUCE_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Produce Communication
Y/N Table Edit
Default Value: Y
|