SL_BUSINESS_UNITFROM_BUSINESS_UNITTRANSACTION_CODEPUBIDBCT_PUBID_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT BUSINESS_UNIT , BUSINESS_UNIT , TRANSACTION_CODE , PUBID FROM PS_BCT_CTL WHERE BCT_STATUS IN ('0', '1', '4') AND PUBID <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SL_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit selection field |
| 2 | FROM_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | From Business Unit |
| 3 | TRANSACTION_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 4 | PUBID |
Signed Number(11,0) | DECIMAL(10) NOT NULL | Publication Identifier |