SCC_ETH_FUNC_AREAPRFL=Profile
SSFC=Faculty Center
SSSC=Student Center
EFFDTDefault Value: %date
A=Active
I=Inactive
SCC_ETH_FUNC_VW(SQL View) |
Index Back |
|---|
| SELECT a.FIELDVALUE , a.EFFDT , a.EFF_STATUS , a.XLATLONGNAME FROM PSXLATITEM a WHERE FIELDNAME = 'SCC_ETH_FUNC_AREA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ETH_FUNC_AREA |
Character(4) | VARCHAR2(4) NOT NULL |
Functional Area
PRFL=Profile SSFC=Faculty Center SSSC=Student Center |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |