From:���������������������������������������� Garnick, Everett

Sent:������������������������������������������ Thursday, July 29, 2010 9:13 AM

To:���������������������������������������������� Wurtz, Keith; Smith, James

Cc:���������������������������������������������� Jones, Dianna

Subject:������������������������������������ Grade change history

 

Keith:

 

There is a file named STUDENT.ACAD.CRED.HIST from which you can pull a history of changes made to selected data fields in the STUDENT.ACAD.CRED file. VERIFIED.GRADE is one of those fields. The dictionary of the file looks like the list below:

 

:LISTDICT STUDENT.ACAD.CRED.HIST

;SORT DICT STUDENT.ACAD.CRED.HIST TYP LOC CONV MNAME FORMAT SM ASSOC BY TYP BY

LOC BY @ID 08:51:38 Jul 29 2010 1

@ID............ TYP LOC.......... CONV MNAME.......... FORMAT SM ASSOC.....

 

@ID             D               0      HIST            32L    S

HIST.FIELD.NAME D               1      Field           28L    S

HIST.OLD.VALUES D               2 BL   Old Values      25L    M

HIST.NEW.VALUES D               3 BL   New Values      25L    M

HIST.LOG        D               4      Hist Log        10L    S

HIST.ID         I   FIELD(@ID,"*"      Hist            80L    S

                    ,1)

QBSEC           I   SUBR("QBSEC",                      1R     S

                    "STUDENT.ACAD

                    .CRED.HIST",@

                    ID,@RECORD)

 

A sample of two records listed is shown below. The first is a grade change record showing addition of a grade where one did not exist (�Old Values� is blank). The Id of the records is date*time*operatorid*studentid*changenumber. I�ve highlighted the one for the first record below. The date is in internal format- it is just a number. To see what it is as a date, use Excel and add 24837 to the number in a date-formatted cell. (1/0/1900 is 0 in excel but 0 in Datatel is 12/31/67)

 

 

:LIST STUDENT.ACAD.CRED.HIST HIST.FIELD.NAME HIST.OLD.VALUES HIST.NEW.VALUES HIS

T.LOG

;LIST STUDENT.ACAD.CRED.HIST HIST.FIELD.NAME HIST.OLD.VALUES HIST.NEW.VALUES HI

ST.LOG 08:52:33 Jul 29 2010 1

HIST         13865*46284*CCENTRAL*3857576*1

Field        STC.VERIFIED.GRADE

Old Values

New Values   1

 

HIST         14933*72582*CCENTRAL*3138007*1

Field        STC.STATUS

Old Values   N

New Values   X

             N

 

Give me a call if you have any questions.

 

Everett Garnick

Director, District Computing Services

San Bernardino Community College District

441 West 8th Street

San Bernardino, CA 92401

(909) 384-4360 Office

"The test of courage comes when we are in the minority. The test of tolerance comes when we are in the majority." -- Ralph W. Sockman