HRS_JO_STS_TMP

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHKBOX1_WRK Character(1) VARCHAR2(1) NOT NULL Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
Y/N Table Edit

2 CHKBOX2_WRK Character(1) VARCHAR2(1) NOT NULL Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
Y/N Table Edit

3 CHKBOX3_WRK Character(1) VARCHAR2(1) NOT NULL Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
Y/N Table Edit

4 CHKBOX4_WRK Character(1) VARCHAR2(1) NOT NULL Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
Y/N Table Edit

5 CODE1_WRK Character(3) VARCHAR2(3) NOT NULL Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.

6 CODE2_WRK Character(3) VARCHAR2(3) NOT NULL Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.

7 CODE3_WRK Character(3) VARCHAR2(3) NOT NULL Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.

8 CODE4_WRK Character(3) VARCHAR2(3) NOT NULL Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHKBOX1_WRK	Character(1)	VARCHAR2(1) NOT NULL	Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status. Y/N Table Edit
2	CHKBOX2_WRK	Character(1)	VARCHAR2(1) NOT NULL	Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status. Y/N Table Edit
3	CHKBOX3_WRK	Character(1)	VARCHAR2(1) NOT NULL	Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status. Y/N Table Edit
4	CHKBOX4_WRK	Character(1)	VARCHAR2(1) NOT NULL	Used in a temporary table to allow applicants/employees/managers to indicate search criteria to be used when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status. Y/N Table Edit
5	CODE1_WRK	Character(3)	VARCHAR2(3) NOT NULL	Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
6	CODE2_WRK	Character(3)	VARCHAR2(3) NOT NULL	Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
7	CODE3_WRK	Character(3)	VARCHAR2(3) NOT NULL	Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.
8	CODE4_WRK	Character(3)	VARCHAR2(3) NOT NULL	Used in a temporary table to identify which search criteria has been selected when viewing job postings. Valid search criteria is built up at run time based on Job function/category and in the case of managers, requisition status.