IB_PACKAGEIDIB_SCHEMANAMEIB_VARIANTNAMEY/N Table Edit
Default Value: N
0=Not Imported
1=Imported
Y/N Table Edit
Default Value: N
PSLSDEFN_VW(SQL View) |
Index Back |
|---|---|
IB Logical Schema View |
| SELECT IB_PACKAGEID , IB_SCHEMANAME , IB_VARIANTNAME , OBJECTOWNERID , IB_ISPRIVATE , IB_ISCONTAINER , IB_ISIMPORTED , DESCR , DESCRLONG FROM PSLSDEFN WHERE IB_ISCMPPRIM <> '1' AND IB_AUTOGENERATED = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_PACKAGEID |
Character(100) | VARCHAR2(100) NOT NULL | Referenced Package |
| 2 | IB_SCHEMANAME |
Character(100) | VARCHAR2(100) NOT NULL | Document Name |
| 3 | IB_VARIANTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Version Name |
| 4 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 5 | IB_ISPRIVATE | Character(1) | VARCHAR2(1) NOT NULL |
Is Private
Y/N Table Edit Default Value: N |
| 6 | IB_ISCONTAINER | Character(1) | VARCHAR2(1) NOT NULL | Message Document |
| 7 | IB_ISIMPORTED | Character(1) | VARCHAR2(1) NOT NULL |
Is Imported
0=Not Imported 1=Imported Y/N Table Edit Default Value: N |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |