TL_BADGE_TBL_VW

(SQL View)
Index Back

TL Badge Table View

This View is used to display the Badge Inforamtion of Badge Type=Clock for a Time Reporter on Create/Maintain Time Reporter Page.

SELECT EMPLID ,EMPL_RCD ,BADGE_TYPE ,EFFDT ,EFF_STATUS ,BADGE_NBR ,COMMENTSHORT FROM PS_BADGE_TBL WHERE BADGE_TYPE='CLK'

# 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 Rcd Nbr

Default Value: 0

Prompt Table: PER_ORG_ASGN_VW

3 BADGE_TYPE Character(3) VARCHAR2(3) NOT NULL Pertains to the Type of Badge for an employee. A Badge Type of "CLOCK" corresponds to specific Time and Labor functionality.
BA=Building Access
CCA=Computer Center Access
CLK=Clock
GB=General Badge
PA=Parking Access
4 EFFDT Date(10) DATE NOT NULL Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 BADGE_NBR Character(20) VARCHAR2(20) NOT NULL Badge Number
7 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment