HEALTH_TESTEFFDTDefault Value: %date
HLTH_CRITERIA_NBRLANGUAGE_CDHLTH_TSTVW_LANG(SQL View) |
Index Back |
|---|---|
Health Test Criteria ViewHEALTH_TST_TBL stores different types of Health Test codes. This is a related language record for HEALTH_TEST_VW. |
| SELECT DISTINCT a.health_test , a.effdt , a.hlth_criteria_nbr , a1.language_cd , a1.descr FROM ps_health_cri_tmpl a ,PS_HEALTH_TST_LANG a1 , ps_health_tst_tbl b WHERE a.health_test = a1.health_test AND 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 a.EFFDT <= c.effdt) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |