SCC_EDS_PROP_VW

(SQL View)
 Index Back

SELECT SCC_ENTITY_ID , SCC_PROP_NAME , SCC_PROP_TYPE , SCC_ENT_LOCK , SCC_ORDER_NBR , FIELDNAME , SCC_SHOW_TO_XML , SCC_PARSE_FROM_XML , SCC_SHOW_LOV_DESCR , SCC_PROP_XML_TAG , SCC_IN_PROD , SCC_IN_STAGE , SCC_PROP_REQUIRED , SCC_PROP_LABEL , SCC_EP_DEFTYPE , SCC_PROP_DEFAULT , SCC_LOV_RECNAME , SCC_LOV_FIELDNAME , SCC_SL_LOV_CONTEXT , SCC_LOV_UID , SCC_EPROP_LIST , SCC_EPROP_ATTRIB , SCC_CAF_ATTRIB_NM , SCC_EPROP_LOV_REQ , SCC_EPROP_SKP_LOV , SCC_ZERO_NUMBER , SCC_PROP_DESCR FROM PS_SCC_ENT_PROPS WHERE SCC_ENTITY_ID IN ( SELECT SCC_ENTITY_ID FROM PS_SCC_ENTITY_REG WHERE SCC_ENTITY_TYPE_ID='SCC_ETYPE_20130116133604')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
2 SCC_PROP_NAME Character(50) VARCHAR2(50) NOT NULL Property Name
3 SCC_PROP_TYPE Character(2) VARCHAR2(2) NOT NULL Property Type
10=String
20=Number
30=Datetime
40=Date
50=Time
4 SCC_ENT_LOCK Number(1,0) SMALLINT NOT NULL Lock

Default Value: 9

5 SCC_ORDER_NBR Number(3,0) SMALLINT NOT NULL Order Number
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 SCC_SHOW_TO_XML Character(1) VARCHAR2(1) NOT NULL to XML

Y/N Table Edit

Default Value: Y

8 SCC_PARSE_FROM_XML Character(1) VARCHAR2(1) NOT NULL Editable

Y/N Table Edit

Default Value: Y

9 SCC_SHOW_LOV_DESCR Character(1) VARCHAR2(1) NOT NULL Show LOV Description

Y/N Table Edit

10 SCC_PROP_XML_TAG Character(50) VARCHAR2(50) NOT NULL Element (XML)
11 SCC_IN_PROD Character(1) VARCHAR2(1) NOT NULL In Production

Y/N Table Edit

Default Value: N

12 SCC_IN_STAGE Character(1) VARCHAR2(1) NOT NULL In Stage

Y/N Table Edit

Default Value: N

13 SCC_PROP_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required

Y/N Table Edit

Default Value: N

14 SCC_PROP_LABEL Character(50) VARCHAR2(50) NOT NULL Label
15 SCC_EP_DEFTYPE Character(2) VARCHAR2(2) NOT NULL Default Type
10=Record
20=Custom
30=Skip

Default Value: 30

16 SCC_PROP_DEFAULT Character(254) VARCHAR2(254) NOT NULL Property Default
17 SCC_LOV_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

Prompt Table: SCC_LOV_REC_PT

18 SCC_LOV_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name

Prompt Table: SCC_LOV_FLD_PT

19 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context

Prompt Table: SCC_LOV_CTXT

20 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID

Prompt Table: SCC_SL_LOV_VW

21 SCC_EPROP_LIST Character(1) VARCHAR2(1) NOT NULL Entity Property List

Y/N Table Edit

Default Value: N

22 SCC_EPROP_ATTRIB Character(1) VARCHAR2(1) NOT NULL Entity Property Attribute

Y/N Table Edit

Default Value: N

23 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
24 SCC_EPROP_LOV_REQ Character(1) VARCHAR2(1) NOT NULL Entity Property Request List of Values

Y/N Table Edit

Default Value: N

25 SCC_EPROP_SKP_LOV Character(1) VARCHAR2(1) NOT NULL Entity Property Skip List of Values

Y/N Table Edit

Default Value: N

26 SCC_ZERO_NUMBER Character(1) VARCHAR2(1) NOT NULL Treat Zero as a Number

Default Value: N

27 SCC_PROP_DESCR Long Character CLOB Description