HR_PG_MVMT_HR_1

(SQL View)
 Index Back

HR Admin's Headcount View

This view is used as the base view for HR Admin's Headcount Movement PG.

SELECT JOB.EMPLID , JOB.EMPL_RCD , JOB.EFFDT , JOB.EFFSEQ , JOB.COMPANY , %Coalesce(( SELECT CMP.DESCR FROM PS_COMPANY_TBL CMP WHERE JOB.COMPANY = CMP.COMPANY AND CMP.EFF_STATUS = 'A' AND CMP.EFFDT = ( SELECT MAX(CMP1.EFFDT) FROM PS_COMPANY_TBL CMP1 WHERE CMP1.COMPANY = CMP.COMPANY AND CMP1.EFF_STATUS = CMP.EFF_STATUS AND CMP1.EFFDT <= JOB.EFFDT)),' ') , JOB.BUSINESS_UNIT , %Coalesce(( SELECT BU.DESCR FROM PS_BUS_UNIT_TBL_HR BU WHERE JOB.BUSINESS_UNIT = BU.BUSINESS_UNIT),' ') , %Coalesce(( SELECT DEPT.DESCR FROM PS_DEPT_TBL DEPT WHERE JOB.SETID_DEPT = DEPT.SETID AND JOB.DEPTID = DEPT.DEPTID AND DEPT.EFFDT = ( SELECT MAX(DEPT1.EFFDT) FROM PS_DEPT_TBL DEPT1 WHERE DEPT.SETID = DEPT1.SETID AND DEPT.DEPTID = DEPT1.DEPTID AND DEPT1.EFFDT <= (JOB.EFFDT))),' ') , %Coalesce(( SELECT JCODE.DESCR FROM PS_JOBCODE_TBL JCODE WHERE JOB.SETID_DEPT = JCODE.SETID AND JOB.JOBCODE = JCODE.JOBCODE AND JCODE.EFFDT = ( SELECT MAX(JCODE1.EFFDT) FROM PS_JOBCODE_TBL JCODE1 WHERE JCODE.SETID = JCODE1.SETID AND JCODE.JOBCODE = JCODE1.JOBCODE AND JCODE1.EFFDT <= (JOB.EFFDT))),' ') , %Coalesce(( SELECT LOC.DESCR FROM PS_LOCATION_TBL LOC WHERE JOB.SETID_DEPT = LOC.SETID AND JOB.LOCATION = LOC.LOCATION AND LOC.EFFDT = ( SELECT MAX(LOC1.EFFDT) FROM PS_LOCATION_TBL LOC1 WHERE LOC.SETID = LOC1.SETID AND LOC.LOCATION = LOC1.LOCATION AND LOC1.EFFDT <= (JOB.EFFDT))),' ') , %Coalesce(( SELECT POSN.DESCR FROM PS_POSITION_DATA POSN WHERE JOB.POSITION_NBR = POSN.POSITION_NBR AND POSN.EFFDT = ( SELECT MAX(POSN1.EFFDT) FROM PS_POSITION_DATA POSN1 WHERE POSN.POSITION_NBR=POSN1.POSITION_NBR AND POSN1.EFFDT <= (JOB.EFFDT))),' ') , %Coalesce(( SELECT X1.XLATLONGNAME FROM PSXLATITEM X1 WHERE X1.FIELDNAME = 'FULL_PART_TIME' AND X1.FIELDVALUE = JOB.FULL_PART_TIME AND X1.EFF_STATUS = 'A' AND X1.EFFDT = ( SELECT MAX(X11.EFFDT) FROM PSXLATITEM X11 WHERE X11.FIELDNAME = X1.FIELDNAME AND X11.FIELDVALUE = X1.FIELDVALUE AND X11.EFF_STATUS=X1.EFF_STATUS AND X11.EFFDT <= (JOB.EFFDT))), ' ') , %Coalesce(( SELECT X2.XLATLONGNAME FROM PSXLATITEM X2 WHERE X2.FIELDNAME = 'PER_ORG' AND X2.FIELDVALUE = JOB.PER_ORG AND X2.EFF_STATUS = 'A' AND X2.EFFDT = ( SELECT MAX(X21.EFFDT) FROM PSXLATITEM X21 WHERE X21.FIELDNAME = X2.FIELDNAME AND X21.FIELDVALUE = X2.FIELDVALUE AND X21.EFF_STATUS=X2.EFF_STATUS AND X21.EFFDT <= (JOB.EFFDT))),' ') , %Coalesce(( SELECT GPPG.DESCR FROM PS_GP_PYGRP GPPG WHERE GPPG.GP_PAYGROUP = JOB.GP_PAYGROUP),' ') , %Coalesce(( SELECT PGRP.DESCR FROM PS_PAYGROUP_TBL PGRP WHERE PGRP.COMPANY = JOB.COMPANY AND PGRP.PAYGROUP = JOB.PAYGROUP AND PGRP.EFF_STATUS = 'A' AND PGRP.EFFDT = ( SELECT MAX(PGRP1.EFFDT) FROM PS_PAYGROUP_TBL PGRP1 WHERE PGRP1.COMPANY = PGRP.COMPANY AND PGRP1.PAYGROUP = PGRP.PAYGROUP AND PGRP1.EFF_STATUS=PGRP.EFF_STATUS AND PGRP1.EFFDT <= (JOB.EFFDT))),' ') , %Coalesce(( SELECT EST.DESCR FROM PS_ESTAB_TBL EST WHERE EST.ESTABID = JOB.ESTABID AND EST.EFF_STATUS = 'A' AND EST.EFFDT = ( SELECT MAX(EST1.EFFDT) FROM PS_ESTAB_TBL EST1 WHERE EST1.ESTABID = EST.ESTABID AND EST1.EFF_STATUS=EST.EFF_STATUS AND EST1.EFFDT <= (JOB.EFFDT))),' ') , PER_D.BIRTHDATE , PER_D.NAME_DISPLAY , %Coalesce(( SELECT X3.XLATLONGNAME FROM PSXLATITEM X3 WHERE X3.FIELDNAME = 'SEX' AND X3.FIELDVALUE = PER_D.SEX AND X3.EFF_STATUS = 'A' AND X3.EFFDT = ( SELECT MAX(X31.EFFDT) FROM PSXLATITEM X31 WHERE X31.FIELDNAME = X3.FIELDNAME AND X31.FIELDVALUE = X3.FIELDVALUE AND X31.EFF_STATUS=X3.EFF_STATUS AND X31.EFFDT <= (JOB.EFFDT))), ' ') , %Coalesce(( SELECT X4.XLATLONGNAME FROM PSXLATITEM X4 WHERE X4.FIELDNAME = 'MAR_STATUS' AND X4.FIELDVALUE = PER_D.MAR_STATUS AND X4.EFF_STATUS = 'A' AND X4.EFFDT = ( SELECT MAX(X41.EFFDT) FROM PSXLATITEM X41 WHERE X41.FIELDNAME = X4.FIELDNAME AND X4.FIELDVALUE = X41.FIELDVALUE AND X41.EFF_STATUS = X4.EFF_STATUS AND X41.EFFDT <= (JOB.EFFDT))), ' ') , CASE WHEN (%Round((%DATEDIFF(PER_D.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) < 25 THEN '<25' ELSE CASE WHEN (%Round((%DATEDIFF(PER_D.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 25 AND 34 THEN '25-34' ELSE CASE WHEN (%Round((%DATEDIFF(PER_D.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 35 AND 44 THEN '35-44' ELSE CASE WHEN (%Round((%DATEDIFF(PER_D.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 45 AND 54 THEN '45-54' ELSE CASE WHEN (%Round((%DATEDIFF(PER_D.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 55 AND 64 THEN '55-64' ELSE CASE WHEN (%Round((%DATEDIFF(PER_D.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) >= 65 THEN '65+' ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 1000 AND MESSAGE_NBR = 30165) END END END END END END,CASE WHEN JOB.ACTION = 'XFR' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 1000 AND MESSAGE_NBR = 30164) ELSE ( SELECT ACT.ACTION_DESCR FROM PS_ACTION_TBL ACT WHERE ACT.ACTION = JOB.ACTION AND ACT.EFF_STATUS = 'A' AND ACT.EFFDT = ( SELECT MAX(ACT1.EFFDT) FROM PS_ACTION_TBL ACT1 WHERE ACT.ACTION = ACT1.ACTION AND ACT.EFF_STATUS = ACT1.EFF_STATUS AND ACT1.EFFDT <= %CurrentDateIn)) END , %Coalesce(( SELECT SA.DESCR FROM PS_SAL_PLAN_TBL SA WHERE SA.SETID = JOB.SETID_DEPT AND SA.SAL_ADMIN_PLAN = JOB.SAL_ADMIN_PLAN AND SA.EFFDT = ( SELECT MAX(SA1.EFFDT) FROM PS_SAL_PLAN_TBL SA1 WHERE SA.SETID = SA1.SETID AND SA.SAL_ADMIN_PLAN = SA1.SAL_ADMIN_PLAN AND SA.EFF_STATUS = SA1.EFF_STATUS AND SA1.EFFDT <= (JOB.EFFDT)) AND SA.EFF_STATUS<>'I'),' '), %Coalesce(( SELECT RR.DESCR50 FROM PS_REG_REGION_TBL RR WHERE RR.REG_REGION = JOB.REG_REGION),' '), %Coalesce(( SELECT S.NAME_DISPLAY FROM PS_PERSONAL_DATA S WHERE S.EMPLID = JOB.SUPERVISOR_ID),' '), %Coalesce(( SELECT A6.DESCR FROM PS_POSITION_DATA A6 WHERE JOB.REPORTS_TO = A6.POSITION_NBR AND A6.EFFDT = ( SELECT MAX(A61.EFFDT) FROM PS_POSITION_DATA A61 WHERE A6.POSITION_NBR = A61.POSITION_NBR AND A61.EFFDT <= (JOB.EFFDT))),' '),JOB.HR_STATUS ,( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HR_STATUS' AND X.FIELDVALUE = JOB.HR_STATUS AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn)),%DateNull ,%DateNull FROM PS_JOB JOB, PS_PERSONAL_DATA PER_D WHERE JOB.EMPLID = PER_D.EMPLID AND JOB.EFFSEQ = ( SELECT MAX(A1.EFFSEQ) FROM PS_JOB A1 WHERE A1.EMPLID = JOB.EMPLID AND A1.EFFDT = JOB.EFFDT AND A1.ACTION = JOB.ACTION AND A1.EMPL_RCD = JOB.EMPL_RCD) AND JOB.ACTION IN ('ADD','ADL','ASC','ASG','DEM','HIR','LOA','LOF','LTD','LTO','PLA','PLV','POI','PRO','REC','REH','RET','RFA','RFD','RFL','RNW','RTS','RWB','RWP','SF4','SF5','SF7','SFE','SFF','SFG','SFI','SFK','SFL','SFN','SFP','SFR','SFS','SFT','SFV','STD','STO','SUS','SWB','TAS','TDL','TER','TWB','TWP','XFR') UNION ALL SELECT W.EMPLID , W.EMPL_RCD , W.EFFDT , W.EFFSEQ , W.COMPANY , %Coalesce(( SELECT CO1.DESCR FROM PS_COMPANY_TBL CO1 WHERE W.COMPANY = CO1.COMPANY AND CO1.EFF_STATUS = 'A' AND CO1.EFFDT = ( SELECT MAX(CO2.EFFDT) FROM PS_COMPANY_TBL CO2 WHERE CO2.COMPANY = CO1.COMPANY AND CO2.EFF_STATUS = CO1.EFF_STATUS AND CO2.EFFDT <= (W.EFFDT))),' ') , W.BUSINESS_UNIT , %Coalesce(( SELECT BU1.DESCR FROM PS_BUS_UNIT_TBL_HR BU1 WHERE W.BUSINESS_UNIT = BU1.BUSINESS_UNIT),' ') , %Coalesce(( SELECT DT1.DESCR FROM PS_DEPT_TBL DT1 WHERE W.SETID_DEPT = DT1.SETID AND W.DEPTID = DT1.DEPTID AND DT1.EFFDT = ( SELECT MAX(DT2.EFFDT) FROM PS_DEPT_TBL DT2 WHERE DT1.SETID = DT2.SETID AND DT1.DEPTID = DT2.DEPTID AND DT2.EFFDT <= (W.EFFDT))),' ') , %Coalesce(( SELECT JC3.DESCR FROM PS_JOBCODE_TBL JC3 WHERE W.SETID_DEPT = JC3.SETID AND W.JOBCODE = JC3.JOBCODE AND JC3.EFFDT = ( SELECT MAX(JC4.EFFDT) FROM PS_JOBCODE_TBL JC4 WHERE JC3.SETID = JC4.SETID AND JC3.JOBCODE = JC4.JOBCODE AND JC4.EFFDT <= (W.EFFDT))),' ') , %Coalesce(( SELECT LT3.DESCR FROM PS_LOCATION_TBL LT3 WHERE W.SETID_DEPT = LT3.SETID AND W.LOCATION = LT3.LOCATION AND LT3.EFFDT = ( SELECT MAX(LT4.EFFDT) FROM PS_LOCATION_TBL LT4 WHERE LT3.SETID = LT4.SETID AND LT3.LOCATION = LT4.LOCATION AND LT4.EFFDT <= (W.EFFDT))),' ') , %Coalesce(( SELECT PD3.DESCR FROM PS_POSITION_DATA PD3 WHERE W.POSITION_NBR = PD3.POSITION_NBR AND PD3.EFFDT = ( SELECT MAX(PD4.EFFDT) FROM PS_POSITION_DATA PD4 WHERE PD3.POSITION_NBR = PD4.POSITION_NBR AND PD4.EFFDT <= (W.EFFDT))),' ') , %Coalesce(( SELECT XL5.XLATLONGNAME FROM PSXLATITEM XL5 WHERE XL5.FIELDNAME = 'FULL_PART_TIME' AND XL5.FIELDVALUE = W.FULL_PART_TIME AND XL5.EFF_STATUS = 'A' AND XL5.EFFDT = ( SELECT MAX(XL51.EFFDT) FROM PSXLATITEM XL51 WHERE XL51.FIELDNAME = XL5.FIELDNAME AND XL51.FIELDVALUE = XL5.FIELDVALUE AND XL51.EFF_STATUS = XL5.EFF_STATUS AND XL51.EFFDT <= (W.EFFDT))),' ') , %Coalesce(( SELECT XL6.XLATLONGNAME FROM PSXLATITEM XL6 WHERE XL6.FIELDNAME = 'PER_ORG' AND XL6.FIELDVALUE = W.PER_ORG AND XL6.EFF_STATUS = 'A' AND XL6.EFFDT = ( SELECT MAX(XL61.EFFDT) FROM PSXLATITEM XL61 WHERE XL61.FIELDNAME = XL6.FIELDNAME AND XL61.FIELDVALUE = XL6.FIELDVALUE AND XL61.EFF_STATUS = XL6.EFF_STATUS AND XL61.EFFDT <= (W.EFFDT))), ' ') , %Coalesce(( SELECT PG3.DESCR FROM PS_GP_PYGRP PG3 WHERE PG3.GP_PAYGROUP = W.GP_PAYGROUP),' ') , %Coalesce(( SELECT NPG3.DESCR FROM PS_PAYGROUP_TBL NPG3 WHERE NPG3.COMPANY = W.COMPANY AND NPG3.PAYGROUP = W.PAYGROUP AND NPG3.EFF_STATUS = 'A' AND NPG3.EFFDT = ( SELECT MAX(NPG31.EFFDT) FROM PS_PAYGROUP_TBL NPG31 WHERE NPG31.COMPANY = NPG3.COMPANY AND NPG31.PAYGROUP = NPG3.PAYGROUP AND NPG31.EFF_STATUS = NPG3.EFF_STATUS AND NPG31.EFFDT <= (W.EFFDT))),' ') , %Coalesce(( SELECT ET3.DESCR FROM PS_ESTAB_TBL ET3 WHERE ET3.ESTABID = W.ESTABID AND ET3.EFF_STATUS = 'A' AND ET3.EFFDT = ( SELECT MAX(ET31.EFFDT) FROM PS_ESTAB_TBL ET31 WHERE ET31.ESTABID = ET3.ESTABID AND ET31.EFF_STATUS = ET3.EFF_STATUS AND ET31.EFFDT <= (W.EFFDT))),' ') , Y.BIRTHDATE , Y.NAME_DISPLAY , %Coalesce(( SELECT XL7.XLATLONGNAME FROM PSXLATITEM XL7 WHERE XL7.FIELDNAME = 'SEX' AND XL7.FIELDVALUE = Y.SEX AND XL7.EFF_STATUS = 'A' AND XL7.EFFDT = ( SELECT MAX(XL71.EFFDT) FROM PSXLATITEM XL71 WHERE XL71.FIELDNAME = XL7.FIELDNAME AND XL71.FIELDVALUE = XL7.FIELDVALUE AND XL71.EFF_STATUS = XL7.EFF_STATUS AND XL71.EFFDT <= (W.EFFDT))), ' ') , %Coalesce(( SELECT XL8.XLATLONGNAME FROM PSXLATITEM XL8 WHERE XL8.FIELDNAME = 'MAR_STATUS' AND XL8.FIELDVALUE = Y.MAR_STATUS AND XL8.EFF_STATUS = 'A' AND XL8.EFFDT = ( SELECT MAX(XL81.EFFDT) FROM PSXLATITEM XL81 WHERE XL81.FIELDNAME = XL8.FIELDNAME AND XL81.FIELDVALUE = XL8.FIELDVALUE AND XL81.EFF_STATUS = XL8.EFF_STATUS AND XL81.EFFDT <= (W.EFFDT))), ' ') , CASE WHEN (%Round((%DATEDIFF(Y.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) < 25 THEN '<25' ELSE CASE WHEN (%Round((%DATEDIFF(Y.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 25 AND 34 THEN '25-34' ELSE CASE WHEN (%Round((%DATEDIFF(Y.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 35 AND 44 THEN '35-44' ELSE CASE WHEN (%Round((%DATEDIFF(Y.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 45 AND 54 THEN '45-54' ELSE CASE WHEN (%Round((%DATEDIFF(Y.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) BETWEEN 55 AND 64 THEN '55-64' ELSE CASE WHEN (%Round((%DATEDIFF(Y.BIRTHDATE,%CURRENTDATEIN))/365 ,0)) >= 65 THEN '65+' ELSE ( SELECT MC3.MESSAGE_TEXT FROM PSMSGCATDEFN MC3 WHERE MC3.MESSAGE_SET_NBR = 1000 AND MC3.MESSAGE_NBR = 30165) END END END END END END ,%Coalesce(( SELECT MC4.MESSAGE_TEXT FROM PSMSGCATDEFN MC4 WHERE MC4.MESSAGE_SET_NBR = 1000 AND MC4.MESSAGE_NBR = 30163), ' ') , %Coalesce(( SELECT SA3.DESCR FROM PS_SAL_PLAN_TBL SA3 WHERE SA3.SETID = W.SETID_DEPT AND SA3.SAL_ADMIN_PLAN = W.SAL_ADMIN_PLAN AND SA3.EFFDT = ( SELECT MAX(SA4.EFFDT) FROM PS_SAL_PLAN_TBL SA4 WHERE SA4.SETID = SA3.SETID AND SA3.SAL_ADMIN_PLAN = SA4.SAL_ADMIN_PLAN AND SA3.EFF_STATUS = SA4.EFF_STATUS AND SA4.EFFDT <= (W.EFFDT)) AND SA3.EFF_STATUS<>'I'),' ') , %Coalesce(( SELECT RR3.DESCR50 FROM PS_REG_REGION_TBL RR3 WHERE RR3.REG_REGION = W.REG_REGION),' '), %Coalesce(( SELECT S.NAME_DISPLAY FROM PS_PERSONAL_DATA S WHERE S.EMPLID = W.SUPERVISOR_ID),' '), %Coalesce(( SELECT PD3.DESCR FROM PS_POSITION_DATA PD3 WHERE W.REPORTS_TO = PD3.POSITION_NBR AND PD3.EFFDT = ( SELECT MAX(PD4.EFFDT) FROM PS_POSITION_DATA PD4 WHERE PD3.POSITION_NBR = PD4.POSITION_NBR AND PD4.EFFDT <= (W.EFFDT))),' '),W.HR_STATUS ,( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HR_STATUS' AND X.FIELDVALUE = W.HR_STATUS AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn)), %DateNull , %DateNull FROM PS_JOB W , PS_JOB X , PS_PERSONAL_DATA Y WHERE W.EMPLID = X.EMPLID AND W.EMPL_RCD = X.EMPL_RCD AND W.EFFSEQ = X.EFFSEQ AND Y.EMPLID = W.EMPLID AND W.ACTION = X.ACTION AND X.ACTION = 'XFR' OR (X.ACTION = 'POS' AND X.ACTION_REASON = 'XFR') AND W.EFFDT = ( SELECT MAX(AA1.EFFDT) FROM PS_JOB AA1 WHERE AA1.EMPLID = X.EMPLID AND AA1.EMPL_RCD = X.EMPL_RCD AND AA1.EFFSEQ = X.EFFSEQ AND AA1.EFFDT < X.EFFDT ) AND Y.EMPLID = W.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
6 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
9 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
10 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
11 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
12 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
14 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
15 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
16 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
17 ESTAB_DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 BIRTHDATE Date(10) DATE Date of Birth
19 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
20 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
21 DESCR5 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
22 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
23 DESCR100_2 Character(100) VARCHAR2(100) NOT NULL Description
24 DESCR6 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
25 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
26 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
27 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
28 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive
29 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
30 FROM_DT Date(10) DATE From Date
31 TO_DT Date(10) DATE To Date