| # |
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
|
| 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
|
| 8 |
SCC_PARSE_FROM_XML |
Character(1) |
VARCHAR2(1) NOT NULL |
Editable
Y/N Table Edit
|
| 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_PROP_DESCR |
Long Character |
CLOB |
Description
|
| 25 |
SCC_EPROP_LOV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Entity Property Request List of Values
Y/N Table Edit
Default Value: N
|
| 26 |
SCC_EPROP_SKP_LOV |
Character(1) |
VARCHAR2(1) NOT NULL |
Entity Property Skip List of Values
Y/N Table Edit
Default Value: N
|
| 27 |
SCC_ZERO_NUMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Treat Zero as a Number
Y/N Table Edit
Default Value: N
|