GM_EC_PROJ_PI (SQL Table)	Index Back
EDI Projects PI It is for PHS 398 form KK. It is used to populate project PI info.

GM_EC_PROJ_PI

(SQL Table)

EDI Projects PI

It is for PHS 398 form KK. It is used to populate project PI info.

# 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 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR

9 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number

10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

11 BIRTHDATE Date(10) DATE Date of Birth

12 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

13 NAME Character(50) VARCHAR2(50) NOT NULL Name

14 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.

15 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

16 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

17 ETHNIC_GROUP Character(1) VARCHAR2(1) NOT NULL Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Specified
7=Native Hawaiian/Oth Pac Island

18 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
1=Native
2=Naturalized
3=Alien Permanent
4=Alien Temporary
5=Permanent resident of U.S.
6=Working Visa
7=Canadian Citizen
8=Other
E=Not Entered
N=Not Indicated

19 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

20 FIRST_TIME_PI Character(1) VARCHAR2(1) NOT NULL First Time PI

21 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type
Prompt Table: GM_PROF_ROLE_TY

#	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	SUB_PROP_NBR	Character(15)	VARCHAR2(15) NOT NULL	SUB_PROP_NBR
9	ROW_NUMBER	Number(3,0)	SMALLINT NOT NULL	Row_Number
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	BIRTHDATE	Date(10)	DATE	Date of Birth
12	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
14	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix 1=Mr. 2=Mrs. 3=Ms.
15	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
16	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
17	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Specified 7=Native Hawaiian/Oth Pac Island
18	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status 1=Native 2=Naturalized 3=Alien Permanent 4=Alien Temporary 5=Permanent resident of U.S. 6=Working Visa 7=Canadian Citizen 8=Other E=Not Entered N=Not Indicated
19	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
20	FIRST_TIME_PI	Character(1)	VARCHAR2(1) NOT NULL	First Time PI
21	PROF_ROLE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Role Type Prompt Table: GM_PROF_ROLE_TY