PBM_ASGN_IDPrompt Table: JOB
Prompt Table: JOB
Prompt Table: BUS_UNIT_TBL_PC
Prompt Table: PROJECT
Prompt Table: PROJ_ACTIVITY
C=Cancelled
E=Ended
O=Open
FO_EMPL_XREF(SQL Table) |
Index Back |
|---|---|
FO Employee XREF Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PBM_ASGN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Assigment ID |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: JOB |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: JOB |
| 4 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: BUS_UNIT_TBL_PC |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table: PROJECT |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACTIVITY |
| 7 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 8 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 9 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Order ID |
| 10 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Order Line |
| 11 | ASSIGN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Assignment Status
C=Cancelled E=Ended O=Open |
| 12 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | Staffing Branch |
| 13 | START_DT | Date(10) | DATE | Start Date |
| 14 | END_DT | Date(10) | DATE | end date |
| 15 | ADDRESS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Address Sequence Number |
| 16 | DEFAULT_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Default Empl Record Nbr |
| 17 | MANAGER_CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Order Contact |
| 18 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 19 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |