HRS_SCREEN_MIL

(SQL Table)
Index Back

Screening Military Rank & Srvc

Screening Military Rank and Service

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
2 MIL_SERVICE Character(5) VARCHAR2(5) NOT NULL Military Service
3 HRS_SCR_USE_SRVC Character(1) VARCHAR2(1) NOT NULL Flag to mark usage in screening
4 HRS_SCR_REQD_SRVC Character(1) VARCHAR2(1) NOT NULL Job Opening Screening Requirement Required
5 HRS_POINTS_SRVC Signed Number(5,0) DECIMAL(4) NOT NULL Default points assigned to an answer.
6 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
7 HRS_SCR_USE_RANK Character(1) VARCHAR2(1) NOT NULL Flag to mark usage in screening
8 HRS_SCR_REQD_RANK Character(1) VARCHAR2(1) NOT NULL Job Opening Screening Requirement Required
9 HRS_POINTS_RANK Signed Number(5,0) DECIMAL(4) NOT NULL Default points assigned to an answer.
10 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id