SSR_BP_ZRAB_NLD

(SQL View)

SELECT DISTINCT A.EMPLID , A.SCC_BRINCD_NLD , A.SSR_BR_RESL_SQ_NLD , A.SSR_BR_RESL_SQ2NLD , A.SSR_BR_AMVB_CD_NLD , A.HEGIS_CODE , ' ' ,%DateNull FROM PS_SSR_BP_ZRDA_NLD A UNION SELECT DISTINCT A.EMPLID , A.SCC_BRINCD_NLD , A.SSR_BR_RESL_SQ_NLD , A.SSR_BR_RESL_SQ2NLD , A.SSR_BR_AMVB_CD_NLD , A.HEGIS_CODE , A.SSR_BR_CERTIFICATE ,A.SSR_BR_RES_DT_NLD FROM PS_SSR_BP_ZRAM_NLD A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

3 SSR_BR_RESL_SQ_NLD Character(20) VARCHAR2(20) NOT NULL Result Sequence Number

4 SSR_BR_RESL_SQ2NLD Character(20) VARCHAR2(20) NOT NULL Result Sequence

5 SSR_BR_AMVB_CD_NLD Character(5) VARCHAR2(5) NOT NULL AMvB Hegis code

6 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code

7 SSR_BR_CERTIFICATE Character(1) VARCHAR2(1) NOT NULL Certificate
N=False
Y=True

8 SSR_BR_RES_DT_NLD Date(10) DATE Result Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	SCC_BRINCD_NLD	Character(4)	VARCHAR2(4) NOT NULL	BRINcode
3	SSR_BR_RESL_SQ_NLD	Character(20)	VARCHAR2(20) NOT NULL	Result Sequence Number
4	SSR_BR_RESL_SQ2NLD	Character(20)	VARCHAR2(20) NOT NULL	Result Sequence
5	SSR_BR_AMVB_CD_NLD	Character(5)	VARCHAR2(5) NOT NULL	AMvB Hegis code
6	HEGIS_CODE	Character(8)	VARCHAR2(8) NOT NULL	HEGIS Code
7	SSR_BR_CERTIFICATE	Character(1)	VARCHAR2(1) NOT NULL	Certificate N=False Y=True
8	SSR_BR_RES_DT_NLD	Date(10)	DATE	Result Date