HRS_POS_DTA_C_1(SQL View) |
Index Back |
---|---|
Position Data Interface VPosition Data Interface View |
SELECT A.POSITION_NBR , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.JOBCODE FROM PS_HCR_POS_DTA_C_I A WHERE ((%EffdtCheck(HCR_POS_DTA_C_I, A, %CurrentDateIn) AND A.EFF_STATUS = 'A') OR (A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HCR_POS_DTA_C_I E WHERE E.POSITION_NBR = A.POSITION_NBR AND E.EFFDT > %CurrentDateIn AND E.EFF_STATUS = 'A') AND NOT EXISTS ( SELECT 'Y' FROM PS_HCR_POS_DTA_C_I F WHERE F.POSITION_NBR = A.POSITION_NBR AND %EffdtCheck(HCR_POS_DTA_C_I, F, %CurrentDateIn) AND F.EFF_STATUS = 'A')) OR (A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HCR_POS_DTA_C_I E WHERE E.POSITION_NBR = A.POSITION_NBR AND E.EFFDT <= %CurrentDateIn AND E.EFF_STATUS = 'A') AND EXISTS ( SELECT 'Y' FROM PS_HCR_POS_DTA_C_I F WHERE F.POSITION_NBR = A.POSITION_NBR AND %EffdtCheck(HCR_POS_DTA_C_I, F, %CurrentDateIn) AND F.EFF_STATUS = 'I') AND NOT EXISTS ( SELECT 'Y' FROM PS_HCR_POS_DTA_C_I F WHERE F.POSITION_NBR = A.POSITION_NBR AND F.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HCR_POS_DTA_C_I F1 WHERE F1.POSITION_NBR = F.POSITION_NBR AND F1.EFFDT > %CurrentDateIn AND F1.EFF_STATUS = 'A')))) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 00000000 |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |