IMMUNIZATIONEFFDTDefault Value: %date
CRITERIA_SEQLANGUAGE_CDIMMUNCRITVWLNG(SQL View) |
Index Back |
|---|---|
Immunization Criteria ViewIMMUNCRITVWLNG is the related language recordfor the record IMMUN_CRIT_VW . IMMUNIZATN_CRIT stores information about each criteria. |
| SELECT DISTINCT a.immunization , a.effdt , a.criteria_seq ,c.language_cd , c.descr FROM ps_immun_crit_tmpl a , ps_immunizatn_tbl b ,PS_IMMNCRITTMPLLNG c WHERE a.IMMUNIZATION=c.IMMUNIZATION AND a.EFFDT=c.EFFDT AND a.CRITERIA_SEQ=c.CRITERIA_SEQ AND a.immunization = b.immunization AND b.eff_status = 'A' AND a.EFFDT = ( SELECT MAX(EFFDT) FROM PS_immun_crit_tmpl c WHERE a.immunization = c.immunization AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IMMUNIZATION |
Character(5) | VARCHAR2(5) NOT NULL | Immunization |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | CRITERIA_SEQ |
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 |