MBL_NOTICES(SQL Table) |
Index Back |
---|---|
Notices Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(4) | VARCHAR2(4) NOT NULL |
Object owner identifier
DBI=Billing DIN=Inventory DOE=Order Entry DOM=Order Management DPO=Purchasing DPV=eProcurement DSP=Services Procurement ETE=Time Entry FAM=Asset Management FAP=Payables FAR=Receivables FCA=Contracts FEX=Expenses FGL=General Ledger FGM=Grants Management FPC=Projects FPG=Program Management FRE=Real Estate Management FRS=Resource Management FTE=Travel FTR=Treasury FWO=Work Order Management HHR=Human Resources YSC=Supply Chain |
|
2 | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 0 |
|
3 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
4 | START_DT | Date(10) | DATE NOT NULL |
Start Date
Default Value: %Date |
5 | END_DT | Date(10) | DATE NOT NULL | End Date |
6 | MBL_PRIORITY_CD | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=High 2=Medium 3=Low Default Value: 2 |
7 | DESCRLONG | Long Character | CLOB | Long Description |