HEALTH_TESTEFFDTDefault Value: %date
HLTH_CRITERIA_NBRHEALTH_TEST_VW(SQL View) |
Index Back |
|---|---|
Health Test Criteria ViewHEALTH_TST_TBL stores different types of Health Test codes. |
| SELECT DISTINCT a.health_test , a.effdt , a.hlth_criteria_nbr , a.descr FROM PS_HEALTH_CRI_TMPL a , ps_health_tst_tbl b WHERE a.health_test = b.health_test AND b.eff_status = 'A' AND a.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HEALTH_CRI_TMPL c WHERE a.health_test = c.health_test AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HEALTH_TEST |
Character(5) | VARCHAR2(5) NOT NULL | Health Test |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | HLTH_CRITERIA_NBR |
Number(2,0) | SMALLINT NOT NULL | Criteria Nbr |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |