Application

sfc.application · every change is kept in the audit log · numbered SFC-{YYYY}-{######}

Fields

Every record also has id, created_at and updated_at.

Field	Label	Type	Rules
student	student	link → core.student	required
agent	agent	link → core.user
service	service	link → sfc.service	required
stage	stage	select	one of: Applied, Verified, Signed, Print, Printed, Dispatched, Done; default "Applied"
status	status	select	one of: Unpaid, New, Accepted, Rejected, Resubmitted, Correction requested, Changed, College confirmation, On hold; default "Unpaid"
delivery_type	delivery type	select	one of: Digital, Courier, Pickup, Mixed
college	college	link → core.college
programme	programme	link → core.programme
amount	amount	money
currency	currency	select	one of: INR, USD; default "INR"
payment_status	payment status	select	one of: Unpaid, Pending offline, Paid, Failed, Refunded; default "Unpaid"
payment_order	payment order	link → payments.payment_order
paid_at	paid at	datetime
education_locked	education locked	check	default false
documents_locked	documents locked	check	default false
purpose_locked	purpose locked	check	default false
college_confirmation	college confirmation	select	one of: Accepted, Rejected, On hold
candidate_remark_type	candidate remark type	select	one of: Paid, Visit
attested_for	attested for	text
student_note	student note	longtext
note_marksheet	note marksheet	longtext
note_transcript	note transcript	longtext
note_degree	note degree	longtext
ocr_result	ocr result	json
verified_by	verified by	link → core.user
verified_at	verified at	datetime
signed_by	signed by	link → core.user
signed_at	signed at	datetime
approved_by	approved by	link → core.user
approved_at	approved at	datetime
print_approved_by	print approved by	link → core.user
print_approved_at	print approved at	datetime
printed_by	printed by	link → core.user
printed_at	printed at	datetime
dispatched_by	dispatched by	link → core.user
dispatched_at	dispatched at	datetime
completed_by	completed by	link → core.user
completed_at	completed at	datetime
rejected_by	rejected by	link → core.user
rejected_at	rejected at	datetime
legacy_id	legacy id	number

Permissions

Role	Can
sfc:admin	read, create, update, delete
sfc:verifier	read, update
sfc:signatory	read, update
sfc:printer	read, update
sfc:dispatcher	read, update
sfc:accounts	read, update
sfc:student	read, create, update — only own rows (via student)
sfc:agent	read, create, update — only own rows (via agent)

API

GET    /api/sfc/application?<field>=<value>&limit=100&offset=0
POST   /api/sfc/application
GET    /api/sfc/application/:id
PATCH  /api/sfc/application/:id
DELETE /api/sfc/application/:id