HRS_RCMN_DT_VW(SQL View) |
Index Back |
|---|---|
Recruitment Index DateRecruitment Index Date |
| SELECT CASE HRS_INDEX_FROM WHEN '6' THEN %DateAdd(%CurrentDateTimeIn,-180) WHEN '12' THEN %DateAdd(%CurrentDateTimeIn,-360) WHEN '18' THEN %DateAdd(%CurrentDateTimeIn,-540) WHEN '24' THEN %DateAdd(%CurrentDateTimeIn,-720) ELSE /* Bug 33764321 fix starts %DateTimeIn('1900-01-01-00.00.00.000000') */ %DateAdd(%DateTimeIn('1900-01-01-00.00.00.000000'),0) /* Bug 33764321 fix ends */ END FROM PS_HRS_SRCHIDX_CTL WHERE HRS_SRCH_INDEX_CD = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |