GM_EC_PERS_KP2

(SQL View)
 Index Back

EDI Key PERSONAL INF

It is for PHS 398 form BB.

SELECT A.ECTRANSID, A.ECQUEUEINSTANCE, A.ECTRANSINOUTSW, '000', A.BUSINESS_UNIT, A.PROPOSAL_ID, A.SUB_PROP_NBR, A.ROW_NUMBER, A.EMPLID, A.PER_TYPE, A.BIRTHDATE, A.MAR_STATUS, A.SEX, A.LANGUAGE_CD, A.NAME, A.NAME_PREFIX, A.NAME_SUFFIX, A.NATIONAL_ID, A.DISABILITY_CD_UK, A.VERSION_ID FROM PS_GM_EC_PERS_KP A, PS_GM_PROP_PROJ B WHERE B.BUSINESS_UNIT=A.BUSINESS_UNIT AND B.PROPOSAL_ID=A.PROPOSAL_ID AND B.SUB_PROP_NBR=A.SUB_PROP_NBR AND B.PRIMARY_FLAG='Y'

# 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 RECORD_ID Character(3) VARCHAR2(3) NOT NULL Record ID
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
7 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
8 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 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
11 BIRTHDATE Date(10) DATE Date of Birth
12 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
13 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
14 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
15 NAME Character(50) VARCHAR2(50) NOT NULL Name
16 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
17 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
18 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
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 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID