INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
ACAD_PROGEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: CAR_PTR_EXC
ACD_PRGTBL_VW(SQL View) |
Index Back |
|---|---|
Academic Program TableThis Academic Program Table view is being used to bring CAR_PTR_EXC_RULE field to Enrollment Request Panel Group buffer by using values of INSTITUTION and ACAD_PROG from same buffer. |
| SELECT DISTINCT A. INSTITUTION ,A.ACAD_PROG ,A.EFFDT ,A.EFF_STATUS ,A.CAR_PTR_EXC_RULE FROM PS_ACAD_PROG_TBL A WHERE EFF_STATUS = 'A' AND A.EFFDT = (SELECT Max(B.EFFDT) FROM PS_ACAD_PROG_TBL B WHERE A.INSTITUTION =B.INSTITUTION AND A.ACAD_PROG = B.ACAD_PROG ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | CAR_PTR_EXC_RULE | Character(10) | VARCHAR2(10) NOT NULL |
Career Pointer Exception Rule
Prompt Table: CAR_PTR_EXC |