GP_NRP_ELNP_VW

(SQL View)
 Index Back

List Set Element Attributes

List Set Element Attributes

SELECT COUNTRY , GP_ELN_SET , EFFDT , PIN_ELEM_GRP_NUM+50000000 , PIN_NUM+50000000 , GP_ELN_ATTR1 , GP_ELN_ATTR2 , GP_ELN_ATTR3 , GP_ELN_ATTR4 , GP_ELN_ATTR5 , GP_ELN_ATTR6 , GP_ELN_ATTR7 , GP_ELN_ATTR8 , GP_ELN_ATTR9 , GP_ELN_ATTR10 , DATA_TYPE_CD FROM PS_GP_ELN_PIN_ATTR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY

2 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group

Prompt Table: GP_PIN_EG0_VW

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 GP_ELN_ATTR1 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
7 GP_ELN_ATTR2 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
8 GP_ELN_ATTR3 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
9 GP_ELN_ATTR4 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
10 GP_ELN_ATTR5 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
11 GP_ELN_ATTR6 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
12 GP_ELN_ATTR7 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
13 GP_ELN_ATTR8 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
14 GP_ELN_ATTR9 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
15 GP_ELN_ATTR10 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
16 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data