HRS_JB_FMLY_TMP(SQL Table) |
Index Back |
|---|
| # | 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. |
| 9 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 10 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 11 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 12 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |