BUSINESS_UNITORDER_IDSKILLCODEPrompt Table: FO_SKILLCODE_VW
C=Career Order
T=Temporary Order
Y/N Table Edit
Default Value: N
AL=Advanced
BL=Beginner
IL=Intermediate
NI=Not Investigated
FOORDRSKILL_UPG(SQL Table) |
Index Back |
|---|---|
Order SkillsSkills the customer is looking for to complete 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 | SKILLCODE |
Character(10) | VARCHAR2(10) NOT NULL |
Skill Code
Prompt Table: FO_SKILLCODE_VW |
| 4 | RS_TYPE | Character(6) | VARCHAR2(6) NOT NULL | Skill Type |
| 5 | ORDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Order
C=Career Order T=Temporary Order |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 8 | YEARS_OF_EXP | Number(5,1) | DECIMAL(4,1) NOT NULL | Years of Work Experience |
| 9 | JOB_RELATED | Character(1) | VARCHAR2(1) NOT NULL |
Job Related
Y/N Table Edit Default Value: N |
| 10 | CONFIDENCE_CD | Character(2) | VARCHAR2(2) NOT NULL |
Confidence
AL=Advanced BL=Beginner IL=Intermediate NI=Not Investigated |
| 11 | COMMENTS | Long Character | CLOB | Comment |