ASSIGNMENT_IDDefault Value: NEXT
P=Pending Replacement
R=Replaced
FO_ASGN_TRACK(SQL Table) |
Index Back |
|---|---|
Assigment tracking replacementAssigment tracking replacement |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Assignment ID
Default Value: NEXT |
| 2 | REPLACED_BY | Character(15) | VARCHAR2(15) NOT NULL | Replaced By |
| 3 | ORIGINAL_ASGN_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 4 | REPLACEMENT_STS | Character(1) | VARCHAR2(1) NOT NULL |
Replacement Status
P=Pending Replacement R=Replaced |
| 5 | REPLAC_REQUEST_DT | Date(10) | DATE | Request Date |
| 6 | REPLAC_START_DT | Date(10) | DATE | Request Date |
| 7 | TIME_START | Time(15) | TIMESTAMP | Start Time |