ASSIGNMENT_IDSEQNOEFFDTDefault Value: %date
FO_MC_ASGRT_SRC(SQL View) |
Index Back |
|---|---|
Assignment InfoAssignment Info - Used to fill in Results Grid in Mass Assignment Rate Changes |
| SELECT DISTINCT DT.ASSIGNMENT_ID , DT.SEQNO , RT.EFFDT FROM PS_RS_ASSGN_DETAIL DT , PS_FO_ASGN_RT_DTL RT WHERE DT.ASSIGNMENT_ID = RT.ASSIGNMENT_ID AND ( (RT.EFFDT BETWEEN DT.START_DT AND DT.END_DT) OR (RT.EFFDT = ( SELECT MAX(RT2.EFFDT) FROM PS_FO_ASGN_RT_DTL RT2 WHERE RT2.ASSIGNMENT_ID = RT.ASSIGNMENT_ID AND RT2.DETAIL_NO = RT.DETAIL_NO AND RT2.EFFDT <= DT.START_DT ) ) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |