HRS_SOURCE_IDEFFDTDefault Value: %date
HRS_SITE_IDHRS_SRCE_SITE_I(SQL View) |
Index Back |
|---|---|
Site SourceSite Source |
| SELECT A.HRS_SOURCE_ID , A.EFFDT , B.HRS_SITE_ID FROM PS_HRS_SOURCE A , PS_HRS_SOURCE_SITE B WHERE A.HRS_SOURCE_ID=B.HRS_SOURCE_ID AND A.EFFDT= B.EFFDT AND A.EFFDT= ( SELECT MAX(X.EFFDT) FROM PS_HRS_SOURCE X WHERE X.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND X.EFFDT <= %CurrentDateIn AND X.HRS_SOURCE_STATUS = '10') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_SOURCE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | HRS_SITE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Site ID |