TELEWORKER_HDR1

(SQL View)
Index Back

Telework Header Details

The view is used as add search record for Teleworker component

SELECT EMPLID ,EMPL_RCD ,NAME ,LAST_NAME_SRCH ,SECOND_LAST_SRCH ,NAME_AC ,MIDDLE_NAME FROM PS_TELEWORKER_HDR

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

Default Value: PER_ORG_ASGN.EMPLID

Prompt Table: TELE_SRCH_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: TELE_SRCH_VW1

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME