EMPLIDSAD_INT_CONTR_NLDPrompt Table: %EDITTABLE6
Prompt Table: %EDITTABLE2
Prompt Table: %EDITTABLE3
Default Value: SAD_BPV_CTR_NLD.START_DATE
Default Value: SAD_BPV_CTR_NLD.END_DATE
SAD_BPV_CNT1_VW(SQL View) |
Index Back |
|---|---|
Prompt view for Prin ContractPrompt view for Principal Contract Number |
| SELECT A.EMPLID , A.SAD_INT_CONTR_NLD , B.DESCR50 , A.HEGIS_CODE , A.ACAD_PROG , A.START_DATE , A.END_DATE FROM PS_SAD_BPV_STC_NLD A , PS_SAD_BPV_CTR_NLD B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND A.HEGIS_CODE = B.HEGIS_CODE AND A.ORG_LOCATION = B.ORG_LOCATION AND A.SAD_INT_CONTR_NLD = B.SAD_INT_CONTR_NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SAD_INT_CONTR_NLD |
Character(16) | VARCHAR2(16) NOT NULL |
Internal contract
Prompt Table: %EDITTABLE6 |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table: %EDITTABLE2 |
| 5 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table: %EDITTABLE3 |
| 6 | START_DATE | Date(10) | DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: SAD_BPV_CTR_NLD.START_DATE |
| 7 | END_DATE | Date(10) | DATE NOT NULL |
End Date
Default Value: SAD_BPV_CTR_NLD.END_DATE |