PTIADEPPROCESSPTIADEPRANGEIDPTIADEPRANGE_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIADEPPROCESS |
Character(8) | VARCHAR2(8) NOT NULL | Dep Calc Process Type |
| 2 | PTIADEPRANGEID |
Number(3,0) | SMALLINT NOT NULL | Dependence Range ID |
| 3 | PTIADEPRANGESTR | Character(12) | VARCHAR2(12) NOT NULL | Range String |