GM_EC_PERS_PI

(SQL Table)
Index Back

EDI PI INF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
11 PER_TYPE Character(1) VARCHAR2(1) NOT NULL Person Type
A=Applicant
C=Cobra Participant
D=GP Dependent/Beneficiary
E=Leased Worker
I=Independent Contractor
L=Time & Labor Contractor
M=Temporary Worker
N=Non HR Administered Employee
O=Other Non-Employee
P=Pension Payee
S=Stock Non-Employee
T=Training Non-Employee
U=Succession Candidate Non-Emplo
12 BIRTHDATE Date(10) DATE Date of Birth
13 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
M=Married
S=Single
U=Unknown
W=Widowed
14 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
15 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
16 NAME Character(50) VARCHAR2(50) NOT NULL Name
17 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
18 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
19 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
20 DISABILITY_CD_UK Character(3) VARCHAR2(3) NOT NULL Disability
DXT=Manual Dexterity
HRN=Hearing
LRN=Learning
MBL=Mobility
MNH=Mental Handicap
MNI=Mental Illness
OTH=Other
RSP=Respiratory
SPC=Speech
UNS=Unspecified
VSN=Vision
21 FIRST_TIME_PI Character(1) VARCHAR2(1) NOT NULL First Time PI
22 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
23 SETID Character(5) VARCHAR2(5) NOT NULL SetID
24 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
25 DEGREE_EARNED Character(30) VARCHAR2(30) NOT NULL Degree Earned
26 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
27 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
28 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
29 CREDENTIAL Character(60) VARCHAR2(60) NOT NULL Credentials
30 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
31 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type