GVT_PAR_RMK_VW

(SQL View)
 Index Back

PAR Remarks

7/23/03 Lee - ICE 608075000 - Replace seq_no with seq_no3. The new field has a numeric 3 attribute, versus a numeric 2 attribute.

SELECT Z.EMPLID,Z.EMPL_RCD, Z.GVT_IRR_TYPE, Z.EFFDT,Z.EFFSEQ, A.EFFDT, A.EFFSEQ, A.GVT_SF50_REMARK, A.GVT_INSERT_REQD, A.GVT_REMARK_LINE1, A.GVT_REMARK_LINE2, A.GVT_REMARK_LINE3, A.GVT_REMARK_LINE4, A.GVT_REMARK_LINE5, A.GVT_REMARK_LINE6, A.GVT_REMARK_LINE7, A.GVT_REMARK_LINE8, A.GVT_REMARK_LINE9, B.GVT_IRR_REPORTABLE, B.GVT_ROST_REMARK FROM PS_GVT_PAR_REMARKS A, PS_GVT_SF50_RK_TBL B, PS_GVT_IRR_CONTROL Z WHERE Z.EMPLID=A.EMPLID AND Z.EMPL_RCD=A.EMPL_RCD AND Z.EFFDT >= A.EFFDT AND A.GVT_SF50_REMARK= B.GVT_SF50_REMARK AND B.EFFDT = (SELECT MAX(B1.EFFDT) FROM PS_GVT_SF50_RK_TBL B1 WHERE B1.GVT_SF50_REMARK=A.GVT_SF50_REMARK AND B1.EFFDT <= A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GVT_IRR_TYPE Character(1) VARCHAR2(1) NOT NULL IRR Type based on NOAC
A=Final Disability
C=Correction
D=Death
M=Military Deposit
N=Not Applicable
P=Preliminary Disability
R=Retirement
S=Supplemental
T=Transfer/Resignation
4 EFFDT Date(10) DATE Effective Date
5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 EFFDT_L1 Date(10) DATE Effective Date L1
7 SEQ_NO3 Number(3,0) SMALLINT NOT NULL 7/23/03 Lee - ICE 608075000 - This is a generic sequence number field, with three integer positions.
8 GVT_SF50_REMARK Character(3) VARCHAR2(3) NOT NULL SF50 Remark Code

Prompt Table: GVT_SF50_RK_TBL

9 GVT_INSERT_REQD Character(1) VARCHAR2(1) NOT NULL Insertion Required

Y/N Table Edit

Default Value: GVT_SF50_RK_TBL.GVT_INSERT_REQD

10 GVT_REMARK_LINE1 Character(72) VARCHAR2(72) NOT NULL Remark Line 1

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE1

11 GVT_REMARK_LINE2 Character(72) VARCHAR2(72) NOT NULL Remark Line 2

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE2

12 GVT_REMARK_LINE3 Character(72) VARCHAR2(72) NOT NULL Remark Line 3

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE3

13 GVT_REMARK_LINE4 Character(72) VARCHAR2(72) NOT NULL Remark Line 4

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE4

14 GVT_REMARK_LINE5 Character(72) VARCHAR2(72) NOT NULL Remark Line 5

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE5

15 GVT_REMARK_LINE6 Character(72) VARCHAR2(72) NOT NULL Remark Line 6

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE6

16 GVT_REMARK_LINE7 Character(72) VARCHAR2(72) NOT NULL Remark Line 7

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE7

17 GVT_REMARK_LINE8 Character(72) VARCHAR2(72) NOT NULL Remark Line 8

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE8

18 GVT_REMARK_LINE9 Character(72) VARCHAR2(72) NOT NULL Remark Line 9

Default Value: GVT_SF50_RK_TBL.GVT_REMARK_LINE9

19 GVT_IRR_REPORTABLE Character(1) VARCHAR2(1) NOT NULL IRR Reporting Settings

Y/N Table Edit

20 GVT_ROST_REMARK Character(1) VARCHAR2(1) NOT NULL ROST Reportable

Y/N Table Edit