HRS_JO_DTYP_VW(SQL View) |
Index Back |
---|---|
Job Opening Description TypesDefine Description types that can be used to create a job posting |
SELECT B.HRS_PST_TMPL_ID , A.HRS_JO_DESCR_TYP , A.DESCR , A.DESCRSHORT , A.STATUS , A.DATA_TYPE_CD , B.HRS_SEQ_NUM FROM PS_HRS_JO_DSC_TYP A , PS_HRS_JO_PST_SCTN B WHERE A.HRS_JO_DESCR_TYP=B.HRS_JO_DESCR_TYP AND B.SELECTED = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HRS_PST_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Job opening posting template id
Prompt Table: HRS_JO_TMPL |
2 | HRS_JO_DESCR_TYP | Character(2) | VARCHAR2(2) NOT NULL | Job posting description type |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |
7 | HRS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |