IB_PACKAGEIDIB_SCHEMANAMEIB_LSVARIANTFS_DEFNVARS_VW(SQL View) |
Index Back |
|---|---|
for Map PS Docfor PS Document in Map Definition |
| SELECT DISTINCT IB_PACKAGEID , IB_SCHEMANAME , IB_VARIANTNAME , IB_ISPRIVATE 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_LSVARIANT |
Character(30) | VARCHAR2(30) NOT NULL | Referenced Version |
| 4 | IB_ISPRIVATE | Character(1) | VARCHAR2(1) NOT NULL | Is Private |