ASSIGNMENT_IDDefault Value: NEXT
Prompt Table: FO_ASGN_SRC_VW2
P=Pending Replacement
R=Replaced
FO_ASGN_REPL_VW(SQL View) |
Index Back |
|---|---|
Assigment tracking replacementAssigment tracking replacement |
| SELECT TRACK.ASSIGNMENT_ID , RSAS.REPLACED_ASGN_ID , TRACK.REPLACED_BY , TRACK.ORIGINAL_ASGN_ID , TRACK.REPLACEMENT_STS , TRACK.REPLAC_REQUEST_DT , TRACK.REPLAC_START_DT , TRACK.TIME_START FROM PS_FO_ASGN_TRACK TRACK , PS_RS_ASSIGNMENT RSAS WHERE TRACK.ASSIGNMENT_ID = RSAS.ASSIGNMENT_ID |
| # | 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_ASGN_ID | Character(15) | VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table: FO_ASGN_SRC_VW2 |
| 3 | REPLACED_BY | Character(15) | VARCHAR2(15) NOT NULL | Replaced By |
| 4 | ORIGINAL_ASGN_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 5 | REPLACEMENT_STS | Character(1) | VARCHAR2(1) NOT NULL |
Replacement Status
P=Pending Replacement R=Replaced |
| 6 | REPLAC_REQUEST_DT | Date(10) | DATE | Request Date |
| 7 | REPLAC_START_DT | Date(10) | DATE | Request Date |
| 8 | TIME_START | Time(15) | TIMESTAMP | Start Time |