BUSINESS_UNITORDER_IDORDER_TYPEC=Career Order
T=Temporary Order
FO_ASSIGNMENT_IDEFFDTFO_CSF_IDFO_CSF_DESCRFO_ASGN_CSF_STG(SQL Table) |
Index Back |
|---|---|
Front Office-ASSIGN_CSF_FIELDFO_ASGN_CSF_STG is used as a staging table in moving over Assignment 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 Assignment. |
| # | 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 |
| 4 | FO_ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Assignment ID |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | FO_CSF_ID |
Character(15) | VARCHAR2(15) NOT NULL | Definition ID |
| 7 | FO_CSF_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Customer Field Name |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |