PTIADEPRANGE_VW

 index back

SELECT R1.PTIADEPPROCESS , R1.PTIADEPRANGEID , (CASE WHEN R2.PTIADEPRANGEMIN IS NULL THEN LPAD(TO_CHAR(R1.PTIADEPRANGEMIN) , 5) ||'-' WHEN R2.PTIADEPRANGEMIN = R1.PTIADEPRANGEMIN + 1 THEN LPAD(TO_CHAR(R1.PTIADEPRANGEMIN) , 5) ELSE LPAD(TO_CHAR( R1.PTIADEPRANGEMIN ) , 5)||'-'|| TO_CHAR(R2.PTIADEPRANGEMIN - 1) END ) AS RANGESTR FROM PS_PTIADEPRANGE R1 LEFT JOIN PS_PTIADEPRANGE R2 ON R1.PTIADEPRANGEID = R2.PTIADEPRANGEID - 1 AND R2.PTIADEPPROCESS = R1.PTIADEPPROCESS

PeopleSoft Field Name Field Type Column Type Description
PTIADEPPROCESS Character(8) VARCHAR2(8) NOT NULL Dep Calc Process Type
PTIADEPRANGEID Number(3,0) SMALLINT NOT NULL Dependence Range ID
PTIADEPRANGESTR Character(12) VARCHAR2(12) NOT NULL Range String
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20