BUSINESS_UNITORDER_IDORDER_TYPEC=Career Order
T=Temporary Order
FO_ASSIGNMENT_IDEFFDTDefault Value: %date
FO_ASGN_RT_STG(SQL Table) |
Index Back |
|---|---|
Front Office-ASSIGN_EARNFO_ASGN_RT_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
Default Value: %date |