HMCR_IFC_ATTR5

(SQL Table)
Index Back

Schema Details

Service schema details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HMCR_ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute Name (do service / undoservice)
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

3 HMCR_TYPESWITCH Character(1) VARCHAR2(1) NOT NULL identifies if element in the service is simple or Complex type
C=Complex Type
S=Simple Type

Default Value: S

4 HMCR_SIMPLETYPE Character(3) VARCHAR2(3) NOT NULL Identifies the values types supported for an element
BIN=xsd:hexBinary
BOL=xsd:boolean
DAT=xsd:date
DTM=xsd:dateTime
NUM=xsd:decimal
STR=xsd:string
5 HMCR_ELEMENT_TYPE Character(30) VARCHAR2(30) NOT NULL Complex Element Type
6 HMCR_ELEMENT_NAME Character(30) VARCHAR2(30) NOT NULL Element Name
7 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
8 HMCR_TYPE_MINOCCUR Character(1) VARCHAR2(1) NOT NULL Identify minimum occurence cardinality property
0=0
1=1

Default Value: 0

9 HMCR_TYPE_MAXOCCUR Character(1) VARCHAR2(1) NOT NULL Identify maximum occurence cardinality property
1=1
N=unbounded

Default Value: 1