MIL_TMPL_STATUS

(SQL View)
 Index Back

Disposition Status in Mil Rank

View to prompt for Disposition Status in Military Rank Change Template page

SELECT ACTION , MIL_RANK_CHNG_STAT FROM PS_MIL_RANK_STATUS A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_MIL_RANK_STATUS A1 WHERE A1.ACTION = A.ACTION AND A1.MIL_RANK_CHNG_STAT = A.MIL_RANK_CHNG_STAT AND A1.EFFDT <=%CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
2 MIL_RANK_CHNG_STAT Character(4) VARCHAR2(4) NOT NULL Disposition Status
AMD=Amendment
CNA=Cancel by Administrator
CNC=Cancel by Command
NEW=New