| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CAT_ID |
Number(3,0) |
SMALLINT NOT NULL |
ID of catalog field
|
| 2 |
CAT_MNC |
Character(7) |
VARCHAR2(7) NOT NULL |
Abreviation used in place of object field name for cases when characters are limited when refering to field. An example would be views created for each catalog field. We use this field when creating views for this field against the QS_STREAM_ROOT table. Such views are the format: QS_QCP_XXXX_VW
XXXX being a reference to the catalog field name.
|
| 3 |
CAT_DESCR |
Character(20) |
VARCHAR2(20) NOT NULL |
Catalog Field Description
|
| 4 |
CAT_RECNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Primary Record Name
|
| 5 |
CAT_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Name of object field used in catalog
Prompt Table:
QS_PSDBFIELD_VW
|
| 6 |
COLRT_ID |
Number(4,0) |
SMALLINT NOT NULL |
Column Type
Default Value: 0
Prompt Table:
QS_COLRT
|
| 7 |
QS_PROMPT_TBL |
Character(24) |
VARCHAR2(24) NOT NULL |
Validation table/view name
Prompt Table:
QS_PSRECDEFN_VW
|
| 8 |
CAT_RESTRICTS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Restrictions code for limiting use of qs catalog fields- currently (01/2000) the choices are Hierarchy, Trace and Inactive. HIER means that the field can be used as both hierarhcy OR Trace. TRAC means that the field can be used as Trace ONLY. Developer: RRE
HIER=Hierarchy Only
IN=Inactive
TRAC=Traceability Only
|
| 9 |
QS_FIELD_OWNER_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Application owner - code specifying which PeopleSoft application originates/maintains the catalog field
CP=Product Configurator
DP=Demand Planning
EG=Engineering
EP=Enterprise Planning
HR=Human Resources
INV=Inventory
MG=Manufacturing
OM=Order Management
PL=Production Planning
PO=Purchasing
QS=Quality
USER=User Defined
|
| 10 |
QS_SETCTRL_FLD |
Character(13) |
VARCHAR2(13) NOT NULL |
Set Control Field
BU=Business Unit
NONE=None
SETD=SetID
Default Value: NONE
|
| 11 |
QS_SELECT_DTYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Specify datatype for SQL/Select verifictaion
CHAR=Character
NUM=Numeric
Default Value: CHAR
|
| 12 |
QS_QSX_TRFIELDNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
This field holds the name used for this field in qs_qsx_data_vw. Normally field names are identical, but since hierarchy fields in the catalog are also usable as trace fields, we need a way to distinguish where they're coming from when both are used in the same view (qs_qsx_data_vw).
Default Value: QS_CATALOG.CAT_FIELDNAME
|
| 13 |
QS_FLD_LABEL_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Select field label type for display - short or long
LONG=Long
SHRT=Short
Default Value: LONG
|
| 14 |
QS_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Switch
N=Inactive
X=Do not use in Search
Y=Active
Y/N Table Edit
Default Value: Y
|
| 15 |
CAT_LABEL_ID |
Character(24) |
VARCHAR2(24) NOT NULL |
used for retrieving app-field labels
|