HRS_JO_MGR_VW

(SQL View)
 Index Back

Job opening manager team vw

Job opening manager team view

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_TM_TYPE , A.EMPLID , A.HRS_JO_TM_PRIMARY , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_TEAM A WHERE A.HRS_JO_TM_TYPE = 'M'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
2 HRS_JO_TM_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Team Type
A=Approver/Reviewer
G=Originator
I=Interviewer
M=Manager
O=Interested Party
R=Recruiter
S=Screening Team

Default Value: M

3 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

Prompt Table: HRS_ACT_MGR_VW

4 HRS_JO_TM_PRIMARY Character(1) VARCHAR2(1) NOT NULL Team Primary
N=No
Y=Yes

Y/N Table Edit

Default Value: N

5 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
6 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
7 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
8 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id