ORG_DEPT_ASOF(SQL View) |
Index Back |
|---|---|
Current Org DepartmentsCurrent External Organization Departments without EFFDT key. |
| SELECT A.EXT_ORG_ID , A.ORG_DEPARTMENT , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.SCHOOL_DEPT_TYPE , A.ORG_LOCATION , A.ORG_CONTACT , A.EMAILID , A.URL_ADDRESS FROM PS_ORG_DEPT A WHERE %EffdtCheck(ORG_DEPT A1, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | ORG_DEPARTMENT |
Number(3,0) | SMALLINT NOT NULL | Department Nbr |
| 3 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: ORG_DEPT.DESCR |
| 7 | SCHOOL_DEPT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
School Department Type
ACD=Academic Department ADM=Administrative Department |
| 8 | ORG_LOCATION | Number(3,0) | SMALLINT NOT NULL |
Location Nbr
Default Value: EXT_ORG_TBL.ORG_LOCATION Prompt Table: ORG_LOCATION |
| 9 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL |
Contact Nbr
Prompt Table: ORG_CONTACT |
| 10 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 11 | URL_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | URL Address |