GPBR_NRP_ERR_VW

(SQL View)
Index Back

Employee Registry BRA

View for Employee Registry Report Temp C BRA

SELECT OPRID ,RUN_CNTL_ID ,EMPLID ,EMPL_rcd ,PIN_TAKE_NUM + 50000000 ,BGN_DT ,END_DT ,EVT_CONFIG1 ,ABS_TYPE_OPTN ,DESCR FROM PS_EMPL_REG_TC_BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
6 BGN_DT Date(10) DATE Begin Date
7 END_DT Date(10) DATE end date
8 EVT_CONFIG1 Character(10) VARCHAR2(10) NOT NULL config char
9 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description