BUSINESS_UNITSEQ_NBRREVISIONEN_REV_SCH_VW(SQL View) |
Index Back |
|---|---|
Item Revision Scheme Tbl Vw |
| SELECT BUSINESS_UNIT , SEQ_NBR , REVISION FROM PS_EN_REV_SCHEME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | REVISION |
Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |