CLASSN_CURRENT_AUSEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
01=Above Senior Lecturer
02=Level C
03=Level B
04=Level A
11=Non Academic
DTYA_CURCLS_AUS(SQL Table) |
Index Back |
|---|---|
AUS Info on ClassificationThis Table contains fields required by the Australian Higher Education (DETYA) to maintain Classification codes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLASSN_CURRENT_AUS |
Number(3,0) | SMALLINT NOT NULL | This field identifies the classification term and level for an employee in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes. |
| 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 Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | CLSN_GRP_AUS | Character(2) | VARCHAR2(2) NOT NULL |
This field identifies the classification type and level group for an employee in respect to their current duties. The value will be derived from the Duties classification field.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
01=Above Senior Lecturer 02=Level C 03=Level B 04=Level A 11=Non Academic |