BUSINESS_UNITORDER_IDORDER_TYPEC=Career Order
T=Temporary Order
Default Value: FO_ORDER_STG.ORDER_TYPE
CSF_IDCSF_DESCRFO_ORDERCSF_STG(SQL Table) |
Index Back |
|---|---|
Front Office-ORDER_CSF_FIELDORDER_CSF_FIELD is used as a staging table in moving over Order CSF information from the Front Office. No information is actually stored within the table. The table's only function is to have the same structure so that messages can be processed for application messaging. All inserts into the BO are done via the subscription code for the Order. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_ID |
Character(25) | VARCHAR2(25) NOT NULL | Order ID |
| 3 | ORDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Type of Order
C=Career Order T=Temporary Order Default Value: FO_ORDER_STG.ORDER_TYPE |
| 4 | CSF_ID |
Character(15) | VARCHAR2(15) NOT NULL | CSF Template ID |
| 5 | CSF_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Customer Field Description |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | VALIDATE_DATA_TBL | Character(1) | VARCHAR2(1) NOT NULL | Validate Data Table |
| 8 | LENGTH_MAX | Number(5,0) | INTEGER NOT NULL | Maximum Length |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |